Re: My IF(AND passes logical, but doesn't reveal correct results
- From: NickNick <NickNick.1sx3bz_1122617199.7335@xxxxxxxxxxxxxxxxxxxxx>
- Date: Fri, 29 Jul 2005 00:49:46 -0500
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",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.
--
NickNick
------------------------------------------------------------------------
NickNick's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=25520
View this thread: http://www.excelforum.com/showthread.php?threadid=391207
.
- References:
- Prev by Date: RE: My IF(AND passes logical, but doesn't reveal correct results
- Next by Date: Advice sought: Multiple column sorting
- Previous by thread: RE: My IF(AND passes logical, but doesn't reveal correct results
- Next by thread: Advice sought: Multiple column sorting
- Index(es):
Relevant Pages
|
Loading
