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.
