How do I combine If and AND Formula
Fixed it...thanks.
"Nicole" wrote:
I want to use a IF Formula but need to combine it with an AND Formula as I am
trying to check if the value of a cell is between two values...in my case If
cell is between 12 and 24 show "X".
I came so far as =If(A1=12;"X";"") so now I need to get it also to check if
A1 is smaller than 24. How can I do that?
Regards
Nicole
|