How do I take a cells numeric value and see if it falls inbetween a
range of cells values.

IF(A1 falls between A2:A3, Yes,No)


A1 = 6
A2 = 1
A3 = 10


--
BFiedler
------------------------------------------------------------------------
BFiedler's Profile: http://www.excelforum.com/member.php...o&userid=27262
View this thread: http://www.excelforum.com/showthread...hreadid=469404