Nested IF statement is giving me an UNPARSEABLE error

mjandorf

Hi,

I'm using this formula:

=IF(COUNTIF([Pilot Status]10:[Pilot Status]12, "No") > 0, "No",IF(COUNTIF([Pilot Status]10:[Pilot Status]12,"Hold")>0,"Hold","Yes")))

to show a "No" Symbol if there is at least 1 "No" in the range, if there are zero "No" in the range, then i want it to show a "Hold" symbol if there is at least 1 in the range.  If both of those fail, then i want it to display the "Yes" symbol?

Can anyone help?

 

For additional context, the formula works if I don't NEST if statements and only have one TRUE value and one FALSE value

Andrée Starå

Hi,

Try something like this.

=IF(COUNTIF([Pilot Status]10:[Pilot Status]12; "No") > 0; "No"; IF(COUNTIF([Pilot Status]10:[Pilot Status]12; "Hold") > 0; "Hold"; "Yes"))

The same version but with the below changes for your and others convenience.

=IF(COUNTIF([Pilot Status]10:[Pilot Status]12, "No") > 0, "No", IF(COUNTIF([Pilot Status]10:[Pilot Status]12, "Hold") > 0, "Hold", "Yes"))

Depending on your country you’ll need to exchange the comma to a period and the semi-colon to a comma.

Did it work?

Have a fantastic day!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

Paul Newcome

You just have one too many closing parenthesis on the end...

mjandorf

THANK YOU again!

I realized that my code was fine...i just had an extra ")" at the end of the formula.

Andrée Starå

Excellent!

Easy to miss!

I'm always happy to help!