Formats a number in Roman numerals. Learn more
The ROMAN function in Google Sheets is used to convert a decimal number into Roman numerals. The function takes two arguments:
number: This is the decimal number that you want to convert to Roman numerals.
rule_relaxation (optional): This argument allows you to specify whether you want to apply the strict Roman numeral rules or relax them. By default, this argument is set to 0, which means strict rules are applied.
You can use other values to relax the rules and generate Roman numerals that may not conform to the traditional rules.
Here's an example of how to use the ROMAN function in Google Sheets:
=ROMAN(10)
This formula will convert the number 10 into Roman numerals and return the result as "X".
If you want to relax the rules, you can specify a non-zero value for the rule_relaxation argument. For example:
=ROMAN(4, 1)
This formula will convert the number 4 into Roman numerals while relaxing the rules, resulting in "IIII" instead of the traditional "IV".
Remember that the ROMAN function in Google Sheets has a limitation on the input range.
It can only convert numbers between 1 and 3,999, inclusive. If you try to convert a number outside this range, the function will return an error.