IF(AND(Cellx4,Cellx<12),"Is Between","Is Outside")

--
Regards
Rob
"pallen" wrote in message
...
How do I structure an IF statement if I want to find out if a number is
between two other numbers?

i.e is a cell reference 4 and <12

I have tride numerous combination and can't seem to get it to return the
correct result.