| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Returning true if a number fits between a range
Hi,
I need 2 test whether a number fits between 2 numbers. For example, if A1 contain 10, A2 contains 2, and A3 (my test cell) contains 6 then the test displayed in A4 will show True (or False). The values of A1-A3 will constantly change. Tried many ways to do this but can't figure out the logic. Can someone help Tony |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Returning true if a number fits between a range
=And(Min(A1,A2)<A3,Max(A1,A2)A3)
if the number can equal either of the values then =And(Min(A1,A2)<=A3,Max(A1,A2)=A3) -- Regards, Tom Ogilvy "David" wrote in message ... Hi, I need 2 test whether a number fits between 2 numbers. For example, if A1 contain 10, A2 contains 2, and A3 (my test cell) contains 6 then the test displayed in A4 will show True (or False). The values of A1-A3 will constantly change. Tried many ways to do this but can't figure out the logic. Can someone help Tony |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Returning true if a number fits between a range
=AND(A3<A1,A3A2)
|
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Returning true if a number fits between a range
Should have read (to be inclusive)
=AND(A3<=A1,A3=A2) |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Returning true if a number fits between a range
Tom
First formula worked a treat Many thanks David -----Original Message----- =And(Min(A1,A2)<A3,Max(A1,A2)A3) if the number can equal either of the values then =And(Min(A1,A2)<=A3,Max(A1,A2)=A3) -- Regards, Tom Ogilvy "David" wrote in message ... Hi, I need 2 test whether a number fits between 2 numbers. For example, if A1 contain 10, A2 contains 2, and A3 (my test cell) contains 6 then the test displayed in A4 will show True (or False). The values of A1-A3 will constantly change. Tried many ways to do this but can't figure out the logic. Can someone help Tony . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Returning a value when 2 other values are true | Excel Worksheet Functions | |||
| Find range a value fits to, assign new value based on importance | Excel Worksheet Functions | |||
| I would like a function to return a value that fits its range | Excel Worksheet Functions | |||
| number range returning a text value | New Users to Excel | |||
| Returning a value for a number in a range | Excel Discussion (Misc queries) | |||
Linear Mode
