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.
My nested IF statment =IF([% Complete]3 = 0, "Red", IF([% Complete]3 = 100, "Green", "Yellow")) is setting the symbol to "Yellow" when clearly the statment requires that IF([% Complete]3 = 100 (thie evaluates to true), "Green".
What am I missing?
Sergio,
You have formatted your % complete column as <%>, remove the % formatting and your argument will produce the correct result.
You could also try
=IF([% Complete]3 = 0, "Red", IF([% Complete]3 = 1, "Green", "Yellow"))
Change your IF([% Complete]3 = 100 to IF([% Complete]3 = 1. When it's looking at your % formatted column it sees 1 as 100%, .9 as 90% etc.(I believe putting 100 would make it look for 10,000%)
That way you can keep your % Complete column to % formatting.
As Jeremy mentioned above. You may need to change the data formatting or your formula. Unless you have 100% inputed as a string, 100% is being evaluated as 1 currently in your sheet.
Hi guys! Thanks for you help.
=IF([%complete]19 <70, "Red" ,IF([%complete]19=100, "Green" ,"Yellow")) STILL didn't work. I got an error message
proe,
You'll need to use the values 0.70 and 1
100% = 1 for the purpose of comparisons. Hope this helps!
Cheers,
Ben
