If then else function for ranges of values

Welcome to the New Smartsheet Online Community


You’ll notice that things have changed a bit. If you need help getting oriented, please take a look at the posts here in the Welcome to the Community category.

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

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)

Sign In or Register to comment.