Return true if one or more cells meet qualifications

[LeonardH]

Hello, sorry if this is too easy for some of you looking for amazingly complex puzzles, I'm just stuck in a brain fart though.


I am currently working on a spreadsheet that I use to input a lot of data into. Ideally I would like for a formula to return TRUE if one or more cells contain a value >= 2. The equation I currently have is as follows:




=IF(XOR($B12>=2,$C12>=2,$D12>=2),$A12,"")




Unfortunately at this time, if more than one cell is >= 2 the formula currently returns FALSE.


Does anyone have any ideas?


Thanks!

 

[Fluff]

Simply remove the X from XOR

 

[LeonardH]

Thank you!

 

[Fluff]

You're welcome