Sign in to join the conversation:
The posts in this section are historical and no longer monitored for accuracy. If this discussion interests you and you'd like to join in, please visit the active Community to post and engage.
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
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
Thanks Atus--i'm making progress and really appreciate your help. I used
However when the value is between .5 and .84--the symbol doesn't change to yellow. Make sense?
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!
Happy to help.
