Roman() Function

The Excel ROMAN function converts an Arabic number to Roman. I.e. for a supplied integer, the function returns a text string depicting the roman numeral form of the number.

Syntax

The syntax for the ROMAN function in Microsoft Excel is:

=ROMAN( number, type )

Parameters or Arguments

number

The number that you wish to convert to roman numeral.

type

Optional. It is the type of roman numeral that you wish to convert to. If type is omitted, the ROMAN function will assume a type of 0. It can be any of the following values:

Value	Explanation
0	Classic (default)
1	More concise
2	More concise
3	More concise
4	Simplified
TRUE	Classic
FALSE	Simplified

Roman Function Examples

In the following spreadsheet, the Excel Roman function is used to convert the number 1999 to different forms of Roman numerals.

Formulas:

	A
1	=ROMAN( 1999, 0 )
2	=ROMAN( 1999, 1 )
3	=ROMAN( 1999, 2 )
4	=ROMAN( 1999, 3 )
5	=ROMAN( 1999, 4 )

Results:

	A
1	MCMXCIX
2	MLMVLIV
3	MXMIX
4	MVMIV
5	MIM

Note

Ø  If a negative number is entered as the number parameter, the ROMAN function will return the #VALUE! error.

Ø  If a number greater than 3999 is entered as the number parameter, the ROMAN function will return the #VALUE! error.

Ø  If any of the arguments are input as decimal values, they are truncated to integers.

References

http://www.excelfunctions.net/Excel-Roman-Function.html

https://support.office.com/en-us/article/ROMAN-function-d6b0b99e-de46-4704-a518-b45a0f8b56f5

https://www.techonthenet.com/excel/formulas/roman.php

follow us on http://arivilm.blogspot.in

like us on https://www.facebook.com/Arivilm2501