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
- 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
#VALUE! Error occurs if the supplied argument is > 3999 and < 0.