Symbols not changing based on the value in another cell.

I entered: =IF(%3 > "0%", "Red", IF(%3 > "50%", "Yellow", IF(%3 > "85%", "Green"))) and all the cells are red. Not sure why the formula is wrong! . The icon is in the column "Indicator" and the value is in the column "%". Any help much appreciated

Find more posts tagged with

Formulas

Comments

Atus Bartal

Richard,

try this: =IF(%3 > 0.5, IF(%3 > 0.85, "Green", "Yellow"), "Red")

If you really need it to be plain if the value is 0, then use it this way:

=IF(%3 <> 0, IF(%3 > 0.5, IF(%3 > 0.85, "Green", "Yellow"), "Red"), "")

[both for the 3rd row in the column called "%"]

hoping it helps,

Atus

Richard C

Thanks Atus--i'm making progress and really appreciate your help. I used

=IF(%3 <> 0, IF(%3 > 0.5, IF(%3 > 0.85, "Green", "Yellow"), "Red"), "")

However when the value is between .5 and .84--the symbol doesn't change to yellow. Make sense?

Richard C

ATUS--when i applied the formula into my master sheet (I was using a test sheet to play around with) IT WORKED!

THANK YOU THANK YOU THANK YOU! Hope I can return the favor someday!