ROMAN Function (Functions in Excel)
Number | Roman | |
1 | I | =ROMAN(C4) |
2 | II | =ROMAN(C5) |
3 | III | =ROMAN(C6) |
5 | V | =ROMAN(C7) |
10 | X | =ROMAN(C8) |
1998 | MCMXCVIII | =ROMAN(C9) |
1998 | MCMXCVIII | =ROMAN(C10,0) |
1998 | MLMVLIII | =ROMAN(C11,1) |
1998 | MXMVIII | =ROMAN(C12,2) |
1998 | MVMIII | =ROMAN(C13,3) |
1998 | MVMIII | =ROMAN(C14,4) |
1998 | MCMXCVIII | =ROMAN(C15,TRUE) |
1998 | MVMIII | =ROMAN(C16,FALSE) |
What Does It Do ? |
This function produces a number shown as Roman numerals in various formats. |
Syntax |
=ROMAN(NormalNumber,RomanNumberFormat) |
The RomanNumberFormat can be any of the following. |
0 is Classic. This is used if no format is specified. |
1 is more Concise. |
2 is even more Concise. |
3 is even more Concise still. |
4 is Simplified. |
TRUE is Classic |
FALSE is Simplified |
Formatting |
No special formatting is needed. |
Note |
There is no function to do the opposite calculation of Roman to normal. |
0 comments:
Post a Comment