My IF(AND passes logical, but doesn't reveal correct results

W

Washdc

I am trying to use the IF(AND formula, it seem to pass all the logical, but I
get an error. The help syntax shows =IF(AND(A1="Non-Poss",A2>A3,"NP,"").
Each condition is true, but the formula won't take. First it state it's
missing a closing parenthesis, I put the second parethesis, then it state the
formula is incorrect with no recommended fix.
 
R

Rowan

Try this
=IF(AND(A1="Non-Poss",A2>A3),"NP","")

You were missing a bracket after A3 and a closing double quote after NP.

Regards
Rowan
 
N

NickNick

Your formula is missing a second closing parethesis. The formula shoul
be of the format:

=IF(AND(-test1-,-test2-,...),-value if true-,-value if false-)

Excel is probably confused by the *"NP* and *""* as they are no
testing anything.
 
W

Washdc

Thanks, All the replies were very helpful. I guess I was so tried up with
the formula I overlooked what was obvious to others..
 
W

Washdc

Thanks NickNick, I guess I didn't follow the logical all the way through the
formula. It works fine now.
 
Top