Forum Discussion
Solved
Will I save resource when adding an If function before complicated functions?
Hi! I just have a simple question. Will I save resource by adding an IF function before doing complicated functions? Or Excel will do all the functions first and return the result, no matter if the...
Yes, IF() evaluates expression for the first found (in case of nested IF) TRUE condition and skips the rest. If no TRUE is found it returns result for final FALSE. In opposite to IFS() or SWITCH() which evaluate expressions for every condition.
As Sergei mentioned, generally the answer is yes.
Two blog posts you might find useful are this one from Charles Williams:
Short-circuiting Excel Formulas: IF, CHOOSE, IFS and SWITCH | Excel and UDF Performance Stuff
And this one from me:
#The SWITCH and LET functions – Excel formula performance - flex your data