Min & Max Range Lookup

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

J.W. Aldridge - 22 Feb 2008 22:54 GMT

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?

Reply to this Message

Tyro - 22 Feb 2008 23:04 GMT

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

Tyro

>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
[quoted text clipped - 9 lines]
>
> Any ideas?

Reply to this Message

T. Valko - 22 Feb 2008 23:07 GMT

One way:

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

Signature

Biff
Microsoft Excel MVP

>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
[quoted text clipped - 9 lines]
>
> Any ideas?

Reply to this Message

Ron Coderre - 22 Feb 2008 23:14 GMT

Maybe this?:

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

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

Regards,

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

>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
[quoted text clipped - 9 lines]
>
> Any ideas?

Reply to this Message

J.W. Aldridge - 23 Feb 2008 18:04 GMT

WORKS PERFECTLY!!!

THANX ALL!!

Reply to this Message

Ron Coderre - 23 Feb 2008 18:13 GMT

Glad to help.

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

Regards,

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

> WORKS PERFECTLY!!!
>
> THANX ALL!!

Reply to this Message