Skip to content

How to Use Excel ROMAN Function?

Listen to this article.
ROMAN FunctionPin
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:

Excel ROMAN FunctionPin
Excel ROMAN Function

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.
Roman NumbersPin
Roman 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.


  • 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 Enter 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.

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.

0 or omittedclassic
1More Consice
2More Consice
3More Consice
Form Options

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.
Input ValuePin
Input Value
  • Now, we need to enter the above-mentioned formula to get the result.
Enter the formulaPin
Enter the formula
  • After entering the formula, you need to click the Enter 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.
Input RangePin
Input Range
  • 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.


In this article, you can clearly understand the usage of the Excel ROMAN Function with its syntax, description, and examples. Drop your feedback in the comment section. To learn more about Excel functions, then visit our webpage

Video Tutorial

The following video will show you how to apply the ROMAN function in the Excel worksheet.

Read Also:


Leave a Reply

Your email address will not be published. Required fields are marked *

Share to...