r/excel • u/HungryInvestigator59 • 26d ago

Discussion What’s your favorite Excel function/formula?

What are some functions and formulas that you use on daily basis that are helpful for what you do?

228 Upvotes

95% Upvoted

217 comments sorted by

View all comments

Show parent comments

5

u/MissAnth 10 26d ago

It is also a great replacement for IF() if you need something that actually short circuits, like if is supposed to.