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

Merging Table Cells

Want to create cells that span multiple columns or multiple rows? You do this in Word by merging cells together. Here's how ...

Discover More

Pasting Clean Text

One of the most helpful tools in Word is the ability to paste straight text into a document. This is used so much on my ...

Discover More

Checking if a Workbook is Already Open

Knowing of a workbook is already open can be a prerequisite to your macro working correctly. Here's how to check it out.

Discover More
More DriveTips

Determining the Day of the Week

Need to know what the day of the week is? Sheets provides a handy function that can return a numeric value that represents ...

Discover More

Inserting Rows

As you are developing a spreadsheet, you'll often have the need to insert additional rows into your data. Sheets makes this ...

Discover More

Adding Borders

Adding borders to a cell (or range of cells) is a common way to draw attention to the cell contents. Sheets provides a ...

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 eight minus 2?

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