Create Roman numbers

 2000-02-04    Functions    0    50

Sometimes you need to display a Roman number. The simple numbers are easy to create, but when the numbers are large most peple have trouble getting them right.
The function ROMAN(number,form) will display Roman numbers between 1 and 3999.
The argument form is optional and can be omitted, but can also be used to tell how the Roman number is to be displayed.

Examples:

Formula Returns Form
=ROMAN(1995) MCMXCV classical
=ROMAN(1995,1) MLMVL simple
=ROMAN(1995,2) MXMV more simple
=ROMAN(1995,3) MVM even more simple
=ROMAN(1995,4) MVM simplest


Leave a comment:

Your comment will only be published after it has been moderated and found spam free.
Your e-mail address will only be used to display your Gravatar.