This method transforms an Arabic number to a Roman number in the form of text.
Syntax:
=ROMAN(number, [form])
Parameter list:
number – The Arabic numeral you wish to convert is number.
form – [Optional – 0 by default ] a number that specifies the roman numeral type you desire. From Classic to Simplified, the roman numeral style becomes more succinct as the value of the form increases.
0 denotes stringent precedence restrictions, with I only being able to precede V and X, V only being able to precede X, X only being able to precede L and C, L only being able to precede C, and C only being able to precede D and M. As a result, ROMAN(499,0) equals CDXCIX.
1 denotes a relaxation in which V may come before L and C, and L may come before D and M. As a result, ROMAN(499,1) equals LDVLIV.
2 denotes a further loosening of the rules, in which I may come before L and C, and X may come before D and M. As a result, ROMAN(499,2) is XDIX.
3 denotes a further relaxation, with V perhaps coming before D and M. As a result, ROMAN(499,3) is VDIV.
4 denotes a further loosening, with I perhaps coming before D and M. As a result, ROMAN(499,4) is the ID.
Ask Your Query