Formula Help
 

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=469393

I don't understand this forum..what is the deal..no one ever replies to
my questions. :mad:


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

15 minutes is a slightly unrealistic timeframe in which to expect an answer.

Anyway try:

=if(and(a1a2,a1<a3),"Yes","No")

Hope this helps
Rowan

BFiedler wrote:
I don't understand this forum..what is the deal..no one ever replies to
my questions. :mad:

BFiedler Wrote:
I don't understand this forum..what is the deal..no one ever replies to
my questions. :mad:

At times, patience is a virtue in this forum. And to help you further
understand this forum, a "thank you" reply is usually appreciated when
a reply is given.

Regards.


--
BenjieLop


------------------------------------------------------------------------
BenjieLop's Profile: http://www.excelforum.com/member.php...o&userid=11019
View this thread: http://www.excelforum.com/showthread...hreadid=469393