RE: My IF(AND passes logical, but doesn't reveal correct results
- From: "Rowan" <Rowan@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Thu, 28 Jul 2005 22:26:10 -0700
Try this
=IF(AND(A1="Non-Poss",A2>A3),"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",A2>A3,"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.
.
- References:
- Prev by Date: Re: My IF(AND passes logical, but doesn't reveal correct results
- Next by Date: Re: My IF(AND passes logical, but doesn't reveal correct results
- Previous by thread: Re: My IF(AND passes logical, but doesn't reveal correct results
- Next by thread: Re: My IF(AND passes logical, but doesn't reveal correct results
- Index(es):
Relevant Pages
|
