Nested If Or to control symbol

Hi All,

I'm trying to set a symbol (Red, Yellow, Green) in a column based on the individual values in three columns.

We'll call the columns the contain the values "Carrots Available", "Fudge Available". and "Veal Available" and the column with the symbol "Basket Status".

If Carrots = 2, Fudge = 5, and Veal = 4 then the symbol is Green

If Carrots <2, or Fudge <3, or Veal <3 then the symbol is Red

Any other value and the symbol is yellow.

I feel confident this can be done by nesting but it is a wee bit out of my capabilities to figure it out. I'm currently handling this with conditional formatting setting row colors but I really need to reference the "Basket Status" in another sheet.

Any assistance would be greatly appreciated.

Find more posts tagged with

Formulas

Accepted answers

Mark Cronk

HI @Dave Schierman ,

try:

=IF(AND(Carrots@Row =2, fudge@row=5, veal @row=4),"Green", IF(AND(carrots@row<2, fudge@row<3, veal@row<3), "Red", "Yellow")))

Mark

All comments

Mark Cronk

HI @Dave Schierman ,

try:

=IF(AND(Carrots@Row =2, fudge@row=5, veal @row=4),"Green", IF(AND(carrots@row<2, fudge@row<3, veal@row<3), "Red", "Yellow")))

Mark

Dave Schierman

Thanks for the quick reply @Mark C.

That was almost exactly right. Changed the second AND to OR and removed an extra ). Thank you so much for the help, this was driving me nuts.

Final formula below for anyone searching in the future,

=IF(AND([Carrots]@row = 2, [Fudge]@row = 5, [Veal]@row = 4), "Green", IF(OR([Carrots]@row < 1, [Fudge]@row < 3, [Veal]@row < 3), "Red", "Yellow"))

Cheers

Mark Cronk

The OR is what I meant to type. Thanks for finding the fix. Be well.

Mark

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, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.