How to Use Excel ROMAN Function?

In Excel, we can use various built-in features to perform mathematical operations. Sometimes, we use Roman letters to mention the numbers.

For that, we suggest you use the ROMAN function in Excel. If you don’t know how to use it, then we will help you.

In this article, we will see the usage of Excel ROMAN Function with its syntax, explanation, and examples. Get an official version of MS Excel from the following link:

https://www.microsoft.com/en-in/microsoft-365/excel

Purpose of ROMAN Numerals

• Roman numbers are generally used to denote the chapters of a book.
• These numerals originated from ancient Rome.
• It is represented by combinations of letters from the Latin alphabet.
• Here, in the following image, you can see some Roman numerals with their corresponding numbers.

Description of ROMAN Function

• It is one of the built-in functions in Microsoft Excel.
• This function converts a number to a Roman numeral as text.
• For example, ROMAN(5) returns the Roman numeral V.

Syntax

• Here, you will see the syntax of the ROMAN function.
• To apply this function on your spreadsheet, you have to select a cell and enter the formula in the following format.
• Once you enter the formula, just click on the button to get the result.

=ROMAN(number, [form])

Argument Explanation

Number – The input number that needs to be converted into the Roman numeral.

Form – It is optional. This is the type of numeral that you want.

Note:
If the number is a negative value or greater than 3999 and then it returns #VALUE! Error.

Form: This is an optional one and it is used to specify the type of the Roman number that you want. It ranges between “0, 1, 2, 3, 4, TRUE, and FALSE“. The corresponding Roman type will be printed in the output. Kindly, refer to the below image.

Practical Examples

Let’s see some examples to make it clear how the ROMAN function works on your spreadsheet.

• Initially, you have to open your Excel workbook on your PC and launch a worksheet that has data.
• For example, we have entered an input number in Cell B3, and we are going to get the Roman letter for this input.
• Now, we need to enter the above-mentioned formula to get the result.
• After entering the formula, you need to click the button to get the output, as shown below.
• In the following image, you will see a range of input values, and we will get the roman letters for those numeric values.
• Once you get the first value, you can simply drag down the cell to fill in all remaining values, as shown in the below image.
• By doing the above steps, you can understand how to apply the ROMAN function in the worksheet. You can also refer to the official Microsoft website to know about this ROMAN function.