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.

Find more posts tagged with

Accepted answers

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"))))

All comments

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)! 😫

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.