Returning true if a number fits between a range
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
|