Include an AND formula with nested ifs rygg balls
So as I've built out this sheet, I don't like that my blank lines are showing as green balls. To expand my formula into grey balls I added:
=IF(Variance@row <= 5000, "Green", IF(Variance@row <= 10000, "Yellow", IF(Variance@row > 10001, "Red", "Grey")))
Because my <=5000 causes there to never be a false/" ", how do I add an AND statement to account for blanks? Every time I try, I get an Incorrect Argument Set error.
Help Article Resources
Check out the Formula Handbook template!