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.



Best Answer


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



  • Mark Cronk
    Mark Cronk ✭✭✭✭✭✭

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


    I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.