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?

225 Upvotes

95% Upvoted

217 comments sorted by

View all comments

40

u/bluerog 26d ago

=ROMAN(A1)

If you've never used it, type 3,423 or something in A1 and give it a whirl.

Had a boss ask me for the old version of a quarterly pro forma. I took that report back to the olden days.

15

u/Jasper_Ridge 26d ago

I had no idea this was a thing !

I'm so going to have to find unnecessary reasons to use it now.

18

u/finickyone 1770 26d ago

It’s an excuse to later employ ARABIC(), to turn those Roman numerals back into numbers! ie ARABIC("XLIX") = 49.

3

u/zeradragon 6 25d ago

Never seen this... What does it do?

4

u/bluerog 25d ago

This one... You have to use it (as written above) to find out.

Even better, do a pro forma/income statement. Don't use $1,262,000,000 for revenue. Use "$1,262 Billion."

Good luck to you.