Excel Function : ROMAN

Download now!

Excel Function : ROMAN

Category

Math and trigonometry

Description

Converts an arabic numeral to roman, as text

Microsoft Excel Reference Page

https://support.office.com/en-us/article/ROMAN-function-d6b0b99e-de46-4704-a518-b45a0f8b56f5

Syntax and Description of the ROMAN Excel Function

The syntax for the ROMAN excel function is as follows: ROMAN(number,[form]) where the number argument is the number you want to convert and the form argument is optional and specifies whether to return the result as a string in uppercase (1), lowercase (0), or mixed case (-1). If omitted, the form argument defaults to 1.

About ROMAN Excel Function

The Excel ROMAN function converts a number to text using the Roman numeral system. The function takes one argument: Number - The number to convert. The number must be between 1 and 3999. The result is a string.