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.

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!