Forum Discussion
Excel problem
I am trying to use an IF formula to tell me if a number is greater than and less than two numbers. For example: minimum number is 3, maximum number is 10. Question is, is 7 between these two numbers...
In part the difference between our formulas is that yours applies to the single input value specified by the OP whereas I went for an array of inputs. Comparing like with like we might have
= IF(
MAP(input, LAMBDA(value, MEDIAN(value, bounds) = value)),
"A", "B"
)
= IF(
BYROW(input<TOROW(bounds), XOR),
"A", "B"
)which are somewhat similar.
An interesting difference is that your MEDIAN formula assumes a closed range whereas I have one closed bound and one open.
Indeed. I've been accused of offering 'complex solutions' to simple problems so I must not indulge at each opportunity!
- Big grin! Surely not, how could anyone accuse us of that!