IF? (so close yet so far)

[Deirdre]

Here is the formula my scatterbrained melon came up with:
=IF(((V17=0)*(N17>=1)),SUM(V17/SUM(N17-P17)),"No P2s")

It's not working, of course.

I would like for Y17 to check the value of V17 and N17. *IF* V = 0 AND N17 >=1, then I wish for v17/sum(N17-P17). If V17 = 0 AND N17< 1 then I would like it to return the text of "No P2s".

:: chomps on pencil ::

Your guidance is appreciated.
~Deirdre

 

[Dave Patton]

You can nest the if test if you want

example

=IF(AND(V17>0,N17>=1),V17/(N17-P17),IF(AND(V17=0,N17=0),"","No P2s"))

HTH Dave

 

[Aladin Akyurek]

On 2002-03-14 11:24, Deirdre wrote:
Thank you everyone for your inout and time. I tried them all and still not getting to what I want. Let me try to illustrate, I could very well be doing this the difficult way...

In retrospect, I see I failed to fully explain my dilema. Please accept my apologies.

N17 = 7
V17 = 4
When this occurs, I would like v17/(N17-P17).

N17 = 7
V17 = 0
When this occurs, I would like for it to return "No P2s"

N17 = 0
V17 = 0
When this occurs, I would like for it to return blank or 0 (doesn't matter)

=IF((V17>0)*(N17>0),V17/(N17-P17),IF(V17*(N17>0)=0,"No P2s",0))

 

[Deirdre]

Thank you all ever so much.

This message board (an the old one) have helped me on numerous occasions and I'm very appreciative of this community.