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

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.

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.

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.

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

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.

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.

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