ROMAN
TheROMAN
formula converts a number to a Roman numeral. The function takes a number and an optional rule_relaxation parameter that specifies how strict the function should be when converting the number to Roman numerals. The function is commonly used in historical, educational, and religious contexts.
 How to use
ROMAN
formula?  Examples of using
ROMAN
formula ROMAN
formula not working? Similar formulas to
ROMAN
Usage
Use the ROMAN
formula with the syntax shown below, it has 1 required parameter and 1 optional parameter:
 number (required):
The number to convert to a Roman numeral. Must be between 1 and 3999, inclusive.  rule_relaxation (optional):
An optional parameter that specifies how strict the function should be when converting the number to Roman numerals. Must be one of the following values: 0 (disallow subtractive notation), 1 (allow subtractive notation), or 2 (allow subtractive notation and use 'IV' instead of 'IIII' and 'IX' instead of 'VIIII')
Examples
Here are a few example use cases that explain how to use theROMAN
formula in Google Sheets.
Convert Arabic numerals to Roman numerals
Suppose you have a list of numbers that you want to convert to Roman numerals. You can use the ROMAN
formula to do this quickly and easily.
Create educational materials
If you're creating educational materials about ancient Rome, you may need to include Roman numerals. The ROMAN
formula can help you generate these numerals quickly and accurately.
Create religious materials
Some religious texts use Roman numerals to indicate chapter and verse numbers. The ROMAN
formula can help you generate these numerals quickly and accurately.
Common Mistakes
ROMAN
not working? Here are some common mistakes people make when using the ROMAN
Google Sheets Formula:
Providing a number greater than 3999
The ROMAN function can only convert numbers between 1 and 3999. Providing a number greater than 3999 will return an error.
Providing a nonnumeric value
The ROMAN function can only convert numeric values. Providing a nonnumeric value will return an error.
Forgetting to include the number argument
The ROMAN function requires at least one argument, the number to be converted to Roman Numerals. Forgetting to include this argument will return an error.
Related Formulas
The following functions are similar to ROMAN
or are often used with it in a formula:

ARABIC
The
ARABIC
function returns the Arabic numeral (as a number) corresponding to a given Roman numeral. This function is useful for converting Roman numerals to Arabic numerals, which is helpful in various calculations and data analysis tasks. 
DEC2HEX
The
DEC2HEX
formula is an engineering formula in Google Sheets that converts a decimal number to its hexadecimal equivalent. It is commonly used to convert numbers to a format that is easier to read and work with in certain applications. 
DEC2OCT
The
DEC2OCT
function is an Engineering function in Google Sheets that converts a decimal number to an octal number. The octal number is returned as a text string. The function is most commonly used to convert decimal numbers to octal numbers for use in various calculations and data analysis tasks.
Learn More
You can learn more about the ROMAN
Google Sheets function on Google Support.