Microsoft Office Tutorials and References
In Depth Information
Using =ROMAN() to Finish Movie Credits and =ARABIC() to Convert Back to Digits
Figure 11.22.
Figure 11.22. I wonder whether Dilbert s pointy-haired boss assigns pro-
I wonder whether Dilbert s pointy-haired boss assigns pro-
jects this way.
jects this way.
Using
Using =ROMAN()
=ROMAN() tto Finish
Finish Movie
Movie Credits
Credits and
and =ARABIC()
=ARABIC() tto Convert
Convert Back
Back tto
Digits
Digits
Excel can convert numbers to Roman numerals. If you stay in the theater
after a movie until the end of movie credits, you see that the copyright date
is always expressed in Roman numerals. If you are the next J.J. Abrams, you
can use =ROMAN(2015) or =ROMAN(YEAR(Now())) to generate such a numeral.
Starting in Excel 2013, the =ARABIC() function can convert a Roman numeral
back to a regular number. Whereas =ROMAN() only works with the numbers 1
through 3999, the ARABIC function deals with invalid Roman numerals from
255,000 through 255,000. Leviculus!
Syntax
=ROMAN(number,form)
Search JabSto ::

Custom Search