Thanks:  0
Likes:  0

# Thread: IF? (so close yet so far)

1. 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

2. 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))

3. 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.

## User Tag List

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•