| 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 |
| 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) | |||
Threaded Mode
