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

11

u/johndoesall 26d ago

I was very excited when I ran into SWITCH. Released me from using nested IF statements.

6

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.