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

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