=IF(AND(A14,A1<12),.................)

--
Biff
Microsoft Excel MVP


"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.