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...
Bit beyond me Peter. I am still working on wriggly brackets but I will certainly give it a try.
The 'wriggly brackets' are simply Excel's way of defining an array constant. If you type
={1,2;3,4}
into a cell you will see
Conversely, were you to type
= SEQUENCE(2, 2)
into a cell, it would evaluate to give the same spilt range.
Then, were you to select the expression in the formula bar and press F9, the formula is evaluated and the array constant is displayed as its result.