Hi I want to write a formula in Cell A6 that says, if Cell A1= True, write "Black", and if Cell A2 = True, write "Blue", and if Cell A3 = True, write "Yellow". But if all of them are False, then leave the cell blank.
So it would be possible for A6 to say Black, Blue. Or it could say Blue and Yellow.
I don't want the logic that all cells have to be true for B6 to display anything. which is the basic IF(AND statement, or IF(OR.
So it would be possible for A6 to say Black, Blue. Or it could say Blue and Yellow.
I don't want the logic that all cells have to be true for B6 to display anything. which is the basic IF(AND statement, or IF(OR.