My IF(AND passes logical, but doesn't reveal correct results
- From: Washdc <Washdc@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Thu, 28 Jul 2005 22:02:02 -0700
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.
.
- Follow-Ups:
- Prev by Date: RE: I need help with a macro which will copy a work*** and..
- Next by Date: RE: IF Function
- Previous by thread: problems with RATE function returning #NUM
- Next by thread: Re: My IF(AND passes logical, but doesn't reveal correct results
- Index(es):
Loading
