ExcelBanter - Compare Data

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Compare Data (https://www.excelbanter.com/excel-discussion-misc-queries/46412-compare-data.html)

BFiedler

Compare Data

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

Biff

Hi!

Try this:

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

Biff

"BFiedler" wrote in
message ...

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

All times are GMT +1. The time now is 03:13 PM.