IF statement that sets a drop down symbol

Jason H

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).

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"))

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. 👍️