Include an AND formula with nested ifs rygg balls

Marina Dixon

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.

Mike Wilday

Try this: This will make the blank rows blank. IF you want it to be Grey, then add Grey inbetween the "".

=IF(ISBLANK(Variance@row), "", IF(Variance@row <= 5000, "Green", IF(Variance@row <= 10000, "Yellow", IF(Variance@row > 10001, "Red", "Grey"))))

Mike Wilday

Try this: This will make the blank rows blank. IF you want it to be Grey, then add Grey inbetween the "".

=IF(ISBLANK(Variance@row), "", IF(Variance@row <= 5000, "Green", IF(Variance@row <= 10000, "Yellow", IF(Variance@row > 10001, "Red", "Grey"))))

Mike Wilday

Glad i could help you figure it out! Have a great day!

Marina Dixon

Thank you! Just a side note, if you type the word "Grey" it wont work. You have to use the American spelling "Gray".

Mike Wilday

😁Good catch. I always forget which spelling to use (and I am American)! 😫