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

Dynamic Data Based on Chart Changes

Change the data on which a chart is based and Excel obligingly updates the chart to reflect the change. What if you want to ...

Discover More

Visually Showing a Protection Status

Need to know if a worksheet or workbook is currently protected? Excel provides some tell-tale signs, but here are some ways ...

Discover More

Jumping to an Endnote

Endnotes are often used in documents to document citations and sources. You can jump from endnote to endnote using the ...

Discover More
More DriveTips

Merging Cells

One of the layout tools that Sheets provides allows you to merge together a group of cells. Here's how to use that tool.

Discover More

Keeping Row and Column Headings in Sight

When you create a spreadsheet, it is common to place headings at the top of each column and the left of each row so you can ...

Discover More

Splitting Cells

Need to separate the contents of one cell into multiple cells? It's easy to do when you use the SPLIT function, as described ...

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. 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 six less than 6?

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