Compare Data

BFiedler · Sep 21, 2005

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

Biff · Sep 21, 2005

Hi!

Try this:

=IF(AND(A1>A2,A1<A3),"Yes","No")

Biff