Determining Status by Percentage

I'm trying to determine a risk status based on a percentage. If 59% or less, High Risk. If 60-79%, Off Track. If 80% or higher, On Track.

My formula is =IF(Percentage1 > 80, "On Track", IF(Percentage1 >= 60, "Off Track", "High Risk")), which is coming up as High Risk and it should be Off Track. I tried putting this through the formula generating and it gave me the same formula. Why is it not coming up as Off Track?

Find more posts tagged with

Accepted answers

rrenee

I believe you might need to use percentages for your numbers as well. For example:

=IF(Percentage@row > 0.8, "On Track", IF(Percentage@row >= 0.6, "Off Track","High Risk"))

All comments

rrenee

I believe you might need to use percentages for your numbers as well. For example:

=IF(Percentage@row > 0.8, "On Track", IF(Percentage@row >= 0.6, "Off Track","High Risk"))

JocelynF

This worked perfectly. Thank you, @rrenee !

rrenee

Anytime!😊 @JocelynF

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, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.