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

Moving Macros from the Personal Workbook

Need to move a macro out of your Personal.xlsb workbook and into a regular workbook? You can do it using familiar editing ...

Discover More

Default Units that Change

Word allows you to specify the unit of measurement you would like used in dialog boxes throughout the program. It can get ...

Discover More

Moving Slides

Getting your slides into the order in which you need them is a big part of putting together a presentation. Here are the ways ...

Discover More
MORE DRIVETIPS

Filling Cells

If you need to fill information into a range of cells, one of the fastest ways of doing it is to use the fill handle. This ...

Discover More

Adding a Drawing to Your Spreadsheet

Numbers alone do not define spreadsheets. Google Drive allows you to also add drawings to a spreadsheet, which can be very ...

Discover More

Transposing Information in a Sheet

If you want to turn a range of cells by 90 degrees within a spreadsheet, you need to understand how Sheets can handle the ...

Discover More

Comments for this tip:

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 three minus 1?

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


Links and Sharing
  • Ask a Question
  • Make a Comment
  • Free Business Forms
  • Free Calendars
  • Share