Excel has a function for converting regular (Arabic) numbers to Roman numbers.
Syntax
=ROMAN(number, type of conversion)
Steps
- Type =ROMAN(
- Select or type the cell reference that includes number in Arabic form B3,
- Type the conversion type, or omit C3
- 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:
- Negative numbers
- Numbers greater than 3999
On both occasions, the function returns #VALUE! error.
=ROMAN(B14,C14)