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

Hi,

Try

=IF(AND(A1="Non-Poss",A2>A3),"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",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. 
.

Relevant Pages

  • My IF(AND passes logical, but doesnt reveal correct results
    ... missing a closing parenthesis, I put the second parethesis, then it state the ... Prev by Date: ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Expression error
    ... Now I'm getting an error that says it's missing a closing parenthesis, ... so I added a third closing parenthesis after the ... Double check to make sure the time fields really are ...
    (microsoft.public.access.reports)
  • Re: Formula for stoplight
    ... Looks like you are missing some closing parenthesis at the end of your ... formula which explains why the cursor moves to the end of your formula after ... adjust it, ...
    (microsoft.public.project)
  • Re: deleting a line
    ... Kim André Akerø wrote: ... Write the updated array to the new file ... Missing a closing parenthesis here, but otherwise, yes, something like ...
    (comp.lang.php)
  • Re: My IF(AND passes logical, but doesnt reveal correct results
    ... Your formula is missing a second closing parethesis. ... be of the format: ... Washdc Wrote: ...
    (microsoft.public.excel.worksheet.functions)