IF Statement with Symbols in Sheet Summary

Evelyn Berry

I continue to receive the "UNPARSABLE" error message for the following formula:

=IF([Project % Complete L&P]# = 0, "Extreme", IF([Project % Complete L&P]# < 0.25, "Severe", IF([Project % Complete L&P]# < 0.5, "Moderate", IF([Project % Complete L&P]# < 0.75, "Mild", ([Project % Complete L&P]# = 1, "No Pain" "Very Severe")))))

I am attempting to auto populate symbols (emojis) in a field in the Sheet Summary based from the result in another field in the Sheet Summary, Project % Complete. The Project % Complete field holds a simple formula (=[Project Complete L&P]# / [Project Total L&P]#) based on other fields in the Sheet Summary.

Any insight is appreciated!

Paul Newcome

You only missed an "IF".

=IF([Project % Complete L&P]# = 0, "Extreme", IF([Project % Complete L&P]# < 0.25, "Severe", IF([Project % Complete L&P]# < 0.5, "Moderate", IF([Project % Complete L&P]# < 0.75, "Mild", IF([Project % Complete L&P]# = 1, "No Pain" "Very Severe")))))

Paul Newcome

You only missed an "IF".

=IF([Project % Complete L&P]# = 0, "Extreme", IF([Project % Complete L&P]# < 0.25, "Severe", IF([Project % Complete L&P]# < 0.5, "Moderate", IF([Project % Complete L&P]# < 0.75, "Mild", IF([Project % Complete L&P]# = 1, "No Pain" "Very Severe")))))

Evelyn Berry

You are WONDERFUL... thanks!!! I must admit, my eyes go a bit crossed with the statement formulas.

Paul Newcome

Happy to help! 👍️