ROMAN

Formats a number in Roman numerals. Learn more

Video field
Text

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.

Want even more from Google Sheets?


With Softr, you can turn your spreadsheets into powerful web apps.You can give advanced roles and permissions to each user, build advanced logic and automation flows, customize the design to your needs, and much more.


Softr also offers a growing library of templates for internal tools, client portals, community hubs, and more. The templates come with a Google Sheet or an Airtable base that you can use to store and manage your data easily.


Try Softr now and build your custom web apps in 10 minutes no code required!