Use the AND function

=IF(AND(A1=12,A1<24),"X","") or perhaps you meant
=IF(AND(A1=12,A1<=24),"X","")
Tyro


"Nicole" wrote in message
...
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