ROMAN Function in Excel – Convert Arabic numeral into Roman

ROMAN Function in Excel converts an Arabic numeral into Roman numeral.

Syntax of ROMAN Function in Excel

ROMAN(number,[form])

 

  • Number is the number that needs to converted to Roman numeral
  • form of the Roman numeral returned. Default value is 0.
0 Classic form
1 More Concise
2 More Concise
3 More Concise
4 Simplified form
TRUE Classic form
FALSE Simplified form


Note:
Number should be between 0 and 3999

 

Example of ROMAN Function in Excel

Formula

ROMAN Function in Excel 1

  • Different Roman numeral form is obtained for the value 2999 by providing different Form arguments ranging from 0 to 4. So the result will be
Result

ROMAN Function in Excel 2

#VALUE! Error occurs if the supplied argument is  > 3999 and < 0.

previous-small ROMAN Function in Excel                                                                                                           next_small ROMAN Function in Excel