Logic function for between
 

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.

Logic function for between
 

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.

Logic function for between
 

pallen -

For example, to check the contents of A1,

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

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


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

Logic function for between
 

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