If then else function for ranges of values
Hi all,
For 0-8 sightings, I need the cell to display Emerging, 9-19 Developing, 20-39 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
- All Categories
- 14 Welcome to the Community
- 10.8K Get Help
- 65 Global Discussions
- 69 Industry Talk
- 385 Announcements
- 3.6K Ideas & Feature Requests
- 56 Brandfolder
- 125 Just for fun
- 50 Community Job Board
- 464 Show & Tell
- 40 Member Spotlight
- 44 Power Your Process
- 28 Sponsor X
- 234 Events
- 7.3K Forum Archives
Check out the Formula Handbook template!