Logic function for between

[pallen]

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.

 

[RobWN]

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

 

[Mike Middleton]

pallen -

For example, to check the contents of A1,

=IF(AND(A1>4,A1<12),"It is","It isn't")

- Mike Middleton
http://www.DecisionToolworks.com
Decision Analysis Add-ins for Excel

 

[T. Valko]

=IF(AND(A1>4,A1<12),.................)