Returning true if a number fits between a range

[David]

Hi,

I need 2 test whether a number fits between 2 numbers.
For example, if A1 contain 10, A2 contains 2, and A3 (my
test cell) contains 6 then the test displayed in A4 will
show True (or False). The values of A1-A3 will constantly
change.
Tried many ways to do this but can't figure out the logic.
Can someone help

Tony

 

[Tom Ogilvy]

=And(Min(A1,A2)<A3,Max(A1,A2)>A3)


if the number can equal either of the values then
=And(Min(A1,A2)<=A3,Max(A1,A2)>=A3)

 

[Ben McBen]

=AND(A3<A1,A3>A2)

 

[Ben McBen]

Should have read (to be inclusive)

=AND(A3<=A1,A3>=A2)

 

[David]

Tom
First formula worked a treat
Many thanks

David