Excel Calculation Performance: IFS vs OR

[jmwbowen]

Hello,

I read that an OR function will evaluate ALL logical expressions before returning a result, which seems wasteful because you'd think that as soon as it evaluated a single TRUE expression, it should no longer need to evaluate the remaining expressions.

Does the IFS function also evaluate ALL expressions before coming to a decision, even if the 1st expression resulted in TRUE?

I have a formula (currently an OR function) that contains five logical expressions. Would it be more efficient to use an IFS statement than an OR statement?

OR(expression 1, expression 2, expression 3, expression 4, expression 5)

IFS(expression 1, TRUE, expression 2, TRUE, expression 3, TRUE, expression 4, TRUE, expression 5, TRUE, TRUE, FALSE)

I could order the IFS expressions in order so that the expression most likely to return a TRUE result is 1st, and so on.

Thanks,

Jason

 

[Fluff]

Not quite sure why you are comparing the OR function to the IFS function, rather than nested IF to IFS.
However IFS will evaluate absolutely everything before coming to a decision.