How to use ROMAN numbers

by | Apr 12, 2018 | Excel Tips & Tricks

Excel has a function for converting regular (Arabic) numbers to Roman numbers.

Syntax

=ROMAN(number, type of conversion)

Steps

  1. Type =ROMAN(
  2. Select or type the cell reference that includes number in Arabic form B3,
  3. Type the conversion type, or omit C3
  4. Type ) and press Enter to complete formula

How

The ROMAN function can convert Arabic numbers to Roman in 6 different ways. These different types of conversion can be defined by its 2nd argument. However; to use its Classical type you can omit the argument.

There are 2 occasions both ROMAN function and actual Roman numbers are not supported:

  1. Negative numbers
  2. Numbers greater than 3999

On both occasions, the function returns #VALUE! error.

=ROMAN(B14,C14)