ROMAN

Formulas / ROMAN
Convert 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?
The ROMAN function is a formula in Sourcetable that converts a number to Roman numerals as text.
What arguments does the ROMAN function take?
The ROMAN function takes two arguments:
  • Number - required
  • Form - optional
How do I convert Roman numerals to Arabic numbers?
To convert Roman numerals to Arabic numbers, use the ARABIC function.

Related Functions

Sourcetable Logo

Work smarter

Al is here to help. Leverage the latest models to
analyze spreadsheets, enrich data, and create reports.

Drop CSV