Excel ROMAN Function
This post will guide you how to use Excel ROMAN function with syntax and examples in Microsoft excel.
Table of Contents
The Excel ROMAN function converts an arabic numeral to roman and the format is Text for returned value.
The ROMAN function is a build-in function in Microsoft Excel and it is categorized as a Math and Trigonometry Function.
The ROMAN function is available in Excel 2016, Excel 2013, Excel 2010, Excel 2007, Excel 2011 for Mac.
The syntax of the ROMAN function is as below:
=ROMAN (number, [form])
Where the ROMAN function arguments are:
- number -This is a required argument. The arabic numeral that you want to convert.
- Form -This is an optional argument.it will specify the form of the Roman numeral returned. The Roman numeral style ranges from Classic to Simplified, becoming more concise as the value of form increases.
|0 or omitted||Classic.|
|1||More concise. See example below.|
|2||More concise. See example below.|
|3||More concise. See example below.|
- If the number is negative, the Function will return #VALUE! Error.
- If the number is greater than 3999, the ROMAN function will return #VALUE! Error.
Excel ROMAN Function Examples
The below examples will show you how to use Excel ROMAN Function to convert an arabic numeral to roman.
1# to get the classic Roman numeral style for number 999, enter the following formula in Cell B1.
2# to get more concise version for number 218, enter the following formula in Cell B2.
3# to get more concise version for number 218 (the Form type is 2), enter the following formula in Cell B3.
4# to get more concise version for number 218 (the Form type is 3), enter the following formula in Cell B4.
5 to get the simplified roman numeral style for number 218 (the Form type is 4), enter the following formula in Cell B5.
CommentsSo empty here ... leave a comment!