If then else function for ranges of values
Hi all,
For 08 sightings, I need the cell to display Emerging, 919 Developing, 2039 Proficient, and 40+ Exemplary.
What's wrong with my formula?
=IF(SUM([Sightings in past two weeks]1:[Sightings in past two weeks]4) <= 8, "Emerging", IF(SUM([Sightings in past two weeks]1:[Sightings in past two weeks]4) <= 19, "Developing"), IF(SUM([Sightings in past two weeks]1:[Sightings in past two weeks]4) <= 39, "Proficient", "Exemplary"))
Thanks!
Michelle
Best Answer

Hello Michelle
The error is being triggered because the formula as an extra close bracket after "Developing" ).
So either remove that bracket, or use the following formula:
=IF(SUM([Sightings in past two weeks]1:[Sightings in past two weeks]4) <= 8, "Emerging", IF(SUM([Sightings in past two weeks]1:[Sightings in past two weeks]4) <= 19, "Developing", IF(SUM([Sightings in past two weeks]1:[Sightings in past two weeks]4) <= 39, "Proficient", "Exemplary")))
Best
Nasir (Zealvert)
Answers

Hello Michelle
The error is being triggered because the formula as an extra close bracket after "Developing" ).
So either remove that bracket, or use the following formula:
=IF(SUM([Sightings in past two weeks]1:[Sightings in past two weeks]4) <= 8, "Emerging", IF(SUM([Sightings in past two weeks]1:[Sightings in past two weeks]4) <= 19, "Developing", IF(SUM([Sightings in past two weeks]1:[Sightings in past two weeks]4) <= 39, "Proficient", "Exemplary")))
Best
Nasir (Zealvert)

Works perfectly!
Thank you so much, Nasir!!!!

You're welcome :)
Help Article Resources
Categories
Check out the Formula Handbook template!