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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
 
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.
 
Thanks, All the replies were very helpful. I guess I was so tried up with
the formula I overlooked what was obvious to others..
 
Thanks NickNick, I guess I didn't follow the logical all the way through the
formula. It works fine now.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Logical formatting for multiple values 1
Find certain text in a cell 3
How do I write an IF function using dates? 2
TRUE/FALSE function in IF statement 2
Avoiding redundant calculations 7
Unable to obtain relative reference using conditional formatting 2
Return result of IF logical test in a different cell 1
Logical test in IF statement returning incorrect result 3

Back
Top