When in Rome, Count Like a Roman

by Allen Wyatt
(last updated December 5, 2013)

Sheets includes a function that allows you to convert a number to Roman numerals. This function is called (appropriately enough) ROMAN. The simplest way to use the ROMAN function is as follows:

=ROMAN(456)

All you need to do, obviously, is replace 456 with the number you want converted. You can use any number between 1 and 3999. (Romans apparently never worked with numbers outside this range.)

You can also, if desired, use a second argument to indicate how the resulting Roman numerals should be put together. The different arguments you can use are 0 through 4, with 0 being the default. An argument of 0 returns Roman numerals in the classic form, and 4 returns an extremely simplified Roman numeral. Values between 0 and 4 return progressively more simplified versions.

The simplification of Roman numerals typically only comes into play when dealing with larger numbers. And, in my testing, it has the greatest impact on numbers that have "9"s in them. For instance, the following shows the various levels of simplification of the number 999:

Formula Result
=ROMAN(999,0) CMXCIX
=ROMAN(999,1) LMVLIV
=ROMAN(999,2) XMIX
=ROMAN(999,3) VMIV
=ROMAN(999,4) IM

You should note that the ROMAN function returns a text value, and you therefore cannot use the result in any sort of calculation. That, however, brings up a second function that converts a Roman numeral back into Arabic numbers that can be used in calculations. Can you guess what the name of this function is? If you guessed the obvious—ARABIC—you would be right. It is even easier to use than ROMAN. If, for instance, there was a string of Roman numerals in cell D5, you could use the following to convert them to regular numbers:

=ARABIC(D5)

Thus, if you wanted to do some math and add a value (in cell B7) to a Roman numeral (in cell B6), then you could use the following formula to express the result in Roman numerals:

=ROMAN(ARABIC(B6)+B7)

Author Bio

Allen Wyatt

With more than 50 non-fiction books and numerous magazine articles to his credit, Allen Wyatt is an internationally recognized author. He is president of Sharon Parq Associates, a computer and publishing services company. ...

MORE FROM ALLEN

Keyboard Changes to Unwanted Foreign Language

There you are typing along, minding your own business, when wham! You end up in an entirely different language and you ...

Discover More

Understanding Subroutines

When developing macros, you can create subroutines. This is a great way to reuse common code and make your programming ...

Discover More

Displaying a Result as Minutes and Seconds

When you use a formula to come up with a result that you want displayed as a time, it can be tricky figuring out how to ...

Discover More
More DriveTips

Renaming a Spreadsheet

Need to change the name of an existing spreadsheet? There are two ways you can do it, using either Sheets or Drive.

Discover More

Easy Translations

If you work in an international environment, you may have a need to translate text from one language to another. Sheets ...

Discover More

Creating and Saving a Spreadsheet

Before you can work with numbers, dates, and formulas, you need to create your Sheets spreadsheet. You can do so using ...

Discover More
Comments

If you would like to add an image to your comment (not an avatar, but an image to help in making the point of your comment), include the characters [{fig}] in your comment text. You’ll be prompted to upload your image when you submit the comment. Maximum image size is 6Mpixels. Images larger than 600px wide or 1000px tall will be reduced. Up to three images may be included in a comment. All images are subject to review. Commenting privileges may be curtailed if inappropriate images are posted.

What is one minus 0?

There are currently no comments for this tip. (Be the first to leave your comment—just use the simple form above!)