Min & Max Range Lookup

[J.W. Aldridge]

I have a number in cell A1 (50) I have a larger number in B1 (100).
What formula can i use to search these two values as if they were min
and max, and return a word if found.

Example:

50 100

in C1, i have the value of 75.
in D1, i want it to return "Yes" since it is within range.
if it is not within range, i want to return "No"

Any ideas?

 

[Tyro]

=IF(AND(C1>=A1,C1<=B1),"Yes","No")

Tyro

 

[T. Valko]

One way:

=IF(COUNT(A1:C1)=3,IF(AND(C1>=A1,C1<=B1),"Yes","No"),"")

 

[Ron Coderre]

Maybe this?:

=IF(MEDIAN(A1:C1)=C1,"Yes","No")

Does that help?
--------------------------

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)

 

[J.W. Aldridge]

WORKS PERFECTLY!!!


THANX ALL!!

 

[Ron Coderre]

Glad to help.

--------------------------

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)