EXCEL ROMAN FUNCTION

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.

  • True : Classic
  • False : Simplified

Step By Step Guide of ROMAN Function

  • The #VALUE! error value is returned if the number is negative.
  • The #VALUE! error value is returned if the number is larger than 3999.

Related Functions

HLOOKUP Function

HLOOKUP Function

Explore Now

VLOOKUP Function

VLOOKUP Function

Explore Now

INDEX Function

INDEX Function

Explore Now

MATCH Function

MATCH Function

Explore Now

DATE Function

DATE Function

Explore Now

IF Function

IF Function

Explore Now

OR Function

OR Function

Explore Now

AND Function

AND Function

Explore Now

RANK Function

RANK Function

Explore Now

SUMIF Function

SUMIF Function

Explore Now

XIRR Function

XIRR Function

Explore Now

WORKDAYS Function

WORKDAYS Function

Explore Now