| 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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Falling within a range
Ben
I think you want something like =IF(AND(A1=A2,A1<A3),"YY",IF(A1=A2,"XX","ZZ")) -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England www.nickhodge.co.uk HIS "ben simpson" wrote in message ... 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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Falling within a range
Thank you very much Nick. Exactly what i was looking for. Sometimes one can
look at a problem for too long and not realize the logic. "Nick Hodge" wrote: Ben I think you want something like =IF(AND(A1=A2,A1<A3),"YY",IF(A1=A2,"XX","ZZ")) -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England www.nickhodge.co.uk HIS "ben simpson" wrote in message ... 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 |
| Reply |
| 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) | |||
Linear Mode
