IF statement that sets a drop down symbol

Looking to utilize Harvey balls so when a % Complete is within a range (see below) it defines the proper Harvey ball. I am able to accomplish the formula using 2 variables but unclear how to set for a range?

FORMULA =IF([% Complete]1 >= 0.9, "Green", IF([% Complete]1 <= 0.8, "Red")

Example Ranges for Harvey Ball.

G 90-100 (complete).

Y 80-90 (pending)

R <80 (complete).

Find more posts tagged with

Formulas

Accepted answers

Paul Newcome

You have a few different options actually.

You can assume that nested IF statements work from left to right and stop on the first true value. Which means that any IF it passes up must be false.

You could also utilize the final portion of the IF statement to say that if all others are false, output "this".

Using the second one would be my suggestion in this particular instance and would look like this...

=IF([% Complete]1 >= 0.9, "Green", IF([% Complete]1 <= 0.8, "Red", "Yellow"))

All comments

Paul Newcome

You have a few different options actually.

You can assume that nested IF statements work from left to right and stop on the first true value. Which means that any IF it passes up must be false.

You could also utilize the final portion of the IF statement to say that if all others are false, output "this".

Using the second one would be my suggestion in this particular instance and would look like this...

=IF([% Complete]1 >= 0.9, "Green", IF([% Complete]1 <= 0.8, "Red", "Yellow"))

Jason H

@Paul Newcome - Thanks for the quick response. You nailed it!

Paul Newcome

Happy to help. 👍️

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.