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

Find more posts tagged with

Accepted answers

Nasir@EBC

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)

All comments

Nasir@EBC

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)

Michelle MacAdam

Works perfectly!

Thank you so much, Nasir!!!!

Nasir@EBC

You're welcome :)

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.