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