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

Tags:

• ✭✭✭✭✭✭

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

• ✭✭✭✭✭✭

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 - Thanks for the quick response. You nailed it!

• ✭✭✭✭✭✭

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!