Pretty simple questions but i couldn't find out how it works and i've search almost a week for an answer now.
Example:
/ One Number is above 0 and one below
/ Both Numbers are below 0
/ Both Numbers are above 0
So i want to check 3 or 4 things.
=CHOOSE(1+(B25<0)+(C25<0), "both above", "above and below", "both below")
I used B25
and C25
because from your comment I saw that you want to reference these cells.
If you want to distinguish cases "below and above" from "above and below", use this:
=IF(AND(B25<0,C25<0),"both below", IF(B25<0,"below and above",
IF(C25<0,"above and below","both above")))
p.s.
Your formula (that you posted in the comment) was almost correct but missed some parentheses. It could be fixed like this:
=IF(AND(B25<0,C25<0),"both below",
IF(AND(B25>=0,C25>=0),"both above",
IF(AND(B25<0,C25>=0),"below and above",
IF(AND(B25>=0,C25<0),"above and below"))))
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With