| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Falling within a range
What would be the best way to create a formula to say:
If a A1 is = than A2, the result is XX, and if not ZZ ,and if at the same time A1 is < A3, the result is YY, or the same ZZ. I'm trying to check if a number falls within a range of numbers, it gives me a result, and the result remains until it no longer falls within the same range. Does any of this make any sense? Thank you for looking in....Ben |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Help with using range names in sum function | Excel Worksheet Functions | |||
| Array to named range conversion... | Excel Discussion (Misc queries) | |||
| How to Select a relative range with Using "Find" and Offset() | Excel Discussion (Misc queries) | |||
| Can a formula check for a certain value in a range? | Excel Discussion (Misc queries) | |||
| can a formula check for a certain value in a range? | Excel Discussion (Misc queries) | |||
Threaded Mode
