Excel ROMAN Function

If you want to follow along with this tutorial, please download the example spreadsheet.

Description

The Excel ROMAN function converts an Arabic number to a Roman numeral as text.

Syntax and arguments

Formula syntax

Arguments

Return Value

The ROMAN function returns to a Roman numeral as text.

Errors

#NAME? error value occurs when argument number is non numeric value.

#VALUE! error value occurs when

--Argument number > 3999, or < 0

--Argument form is not the one of values 0,1,2,3,4,TRUE or FALSE.

Remarks

The ROMAN function truncated decimal number to integer number, for example, ROMAN(1.6)=I.

Version

Excel 2003

Usage and Examples

Example: basic usage

The Arabic number is in B4, to convert it to Roman number in different forms in cell D4:D8, please enter formula as this:

=ROMAN($B$4,D4)//or directly use the number and form into the function =ROMAN(1999,0)

Press Enter key to get the result, then drag autofill handle down cells to get Roman numbers in other forms.

Relative Functions:

• Excel RAND Function
  The RAND function returns a random number between 0 and 1.

• Excel RANDBETWEEN Function
  The RANDBETWEEN function returns a random number between two given numbers.

• Excel FLOOR Function
  The FLOOR function rounds a given number down to the nearest multiple of the specified significance.

• Excel FLOOR.MATH Function
  The Excel FLOOR.MATH function rounds a given number down to the nearest integer or nearest multiple of the specified significance.