Forum Discussion
AlphaEra
Aug 22, 2025Copper Contributor
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...
flexyourdata
Aug 22, 2025Iron Contributor
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