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 90100 (complete).
Y 8090 (pending)
R <80 (complete).
Best Answer

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

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
Categories
Check out the Formula Handbook template!