Hi,

Try

=IF(AND(A1="Non-Poss",A2A3),"NP","")

Regards

Govind.

Washdc wrote:
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",A2A3,"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.