Generic selectors
Exact matches only
Search in title
Search in content
Search in posts
Search in pages

Reply To: Excel IFS()

#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:

  1. 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
  2. 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.