Practice free

ROMAN function

ROMAN turns an ordinary number into Roman numerals and returns them as text. It is often used for labels or outlines, and because the result is text it will not add up.

Example

Read it as a sentence: turn the number 1994 into a Roman numeral, which gives MCMXCIV.

Practice this in the app

Syntax

ROMAN(number, [form])

Arguments in [square brackets] are optional.

number (required)
A whole number from 0 to 3999.
form (optional)
How compact the numeral is, 0 (classic, default) to 4 (most simplified).

Returns: The number as a Roman numeral, in text.

What Excel actually returns

Each formula below was run in desktop Excel. The result is exactly what the cell showed, errors included.

FormulaExcel showsCase
=ROMAN(1994) MCMXCIV 1994
=ROMAN(499,0) CDXCIX 499 form 0
=ROMAN(499,1) LDVLIV 499 form 1
=ROMAN(499,2) XDIX 499 form 2
=ROMAN(499,3) VDIV 499 form 3
=ROMAN(499,4) ID 499 form 4
=ROMAN(499,5) #VALUE! Form 5
=ROMAN(4000) #VALUE! 4000

Watch out for

  • Result is text.
  • Numbers above 3999 return #VALUE!.

Where it works

Excel
ROMAN is in every version of Excel from 2007 on.
Google Sheets
Same name, but behaves differently. Sheets ROMAN takes a rule-relaxation argument instead of Excel's numeric form.

Part of Math and trig functions. Every result on this page was measured in desktop Excel, build 16.0.20527. Last updated .