IFS Function

[Jeffrey Mahoney]

How efficient is the IFS function. When I evaluate a formula with IFS, it seems to evaluate all the pairs of logical tests and values BEFORE providing the result even though the the first logical test is true. Is that true for the real calculation or is that a bug/feature of the evaluate formula tool?

Nested IF statements may have there place but are much harder to read. Is the IFS function less efficient?

@Fluff

Fluff said: "Personally I would avoid using the IFS function on something like this as it is less efficient (and therefore slower) than nested IF functions."

Formula add on new Function

 

[Fluff]

Is the IFS function less efficient?

Yes it is, it will evaluate absolutely everything & then find the 1st criteria which returns True, whilst a nested IF function will only evaluate what it needs to.
How bad IFS is will depend on what you are doing & how many cells contain the formula.

 

[Jeffrey Mahoney]

First, Thank you for the response.

I can't express enough dismay at the lack of forethought the MS team used on that. Could there be a good reason to evaluate all the logical tests first? Nope!

 

[Fluff]

Could there be a good reason to evaluate all the logical tests first?

Not that I can think of, it's a retrograde step IMO