17th October 2020 at 11:37
#75035
Tom Howard
Keymaster
Richard,
That’s true. SWITCH() is a useful function. It’s probably easier to use than IFS() but has the following limitations:
- With SWITCH(), there can only be one expression being evaluated and you put it in the first argument. In my example, it would be C11. With IFS(), all of the conditons being tested can be unrelated, so:
If C11 equals 1, return this, otherwise
If G19 equals 2, return that
- The logical condition can only be = (equals). You cannot test > (greater than), < (less than) etc. Seems a silly omission to me.
I’ll put up a list of all the new functions introduced in Excel 2019 in another thread.
Tom Howard.