Thanks Rowan, your assessment were right on. It worked like a charm.

"Rowan" wrote:

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

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

Regards
Rowan

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