ROMAN
Formulas / ROMANConvert numbers to Roman numerals as text.
ROMAN(number, [format])
- number - required, the Arabic numeral to convert
- form - [OPTIONAL] a number that determines the type of Roman numeral to create
Examples
=ROMAN(4)The ROMAN function converts a number to Roman numerals. In this example, the number 4 is converted to Roman numerals, resulting in "IV".
=ROMAN(9)In this example, the number 9 is converted to Roman numerals, resulting in "IX".
=ROMAN(99)In this example, the number 99 is converted to Roman numerals, resulting in "XCIX".
=ROMAN(100)In this example, the number 100 is converted to Roman numerals, resulting in "C".
=ROMAN(1999, 0)In this example, the number 1999 is converted to Roman numerals with 0 decimal places, resulting in "MCMXCIX".
=ROMAN(1999, 2)In this example, the number 1999 is converted to Roman numerals with 2 decimal places, resulting in "MXMIX".
Summary
The ROMAN function is used to convert arabic numerals to Roman numerals. It requires one argument (number) and has one optional argument (form) which determines the type of Roman numeral to create.
- The ROMAN function converts numbers to Roman numerals as text.
- The arguments for the ROMAN function are number and form.
- The number argument should be a whole number.
Frequently Asked Questions
What is the ROMAN function?
What arguments does the ROMAN function take?
- Number - required
- Form - optional
How do I convert Roman numerals to Arabic numbers?
