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

"NickNick" wrote:


Your formula is missing a second closing parethesis. The formula should
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 not
testing anything.



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.


--
NickNick
------------------------------------------------------------------------
NickNick's Profile: http://www.excelforum.com/member.php...o&userid=25520
View this thread: http://www.excelforum.com/showthread...hreadid=391207