Create Roman numbers
2000-02-04 Functions 0 73
Sometimes you need to display a Roman number. The simple numbers are easy to create, but when the numbers are large most peple have trouble getting them right.
The function ROMAN(number,form) will display Roman numbers between 1 and 3999.
The argument form is optional and can be omitted, but can also be used to tell how the Roman number is to be displayed.
Examples:
| Formula | Returns | Form |
|---|---|---|
=ROMAN(1995) |
MCMXCV | classical |
=ROMAN(1995,1) |
MLMVL | simple |
=ROMAN(1995,2) |
MXMV | more simple |
=ROMAN(1995,3) |
MVM | even more simple |
=ROMAN(1995,4) |
MVM | simplest |