The ROMAN function converts an arabic number to Roman, i.e. for a supplied number, the function returns a text string depicting the roman numeral form of the number.

Syntax

=ROMAN(number,[form])

Arguments

Argument Description
number The number that is to be converted to a Roman numeral; must be an integer > 0 and ≤ 3999
[form] Optional. A number specifying the type of roman numeral you want

  [form] Type
  0 (or omitted) Classic
  1 More concise (see examples)
  2 More concise (see examples)
  3 More concise (see examples)
  4 Simplified
  TRUE Classic
  FALSE Simplified

Examples

  A B C
1 Formula Result Notes
2 =ROMAN(999) CMXCIX Classic roman numeral style for 999; [form] defaults to zero
3 =ROMAN(999,0) CMXCIX Classic roman numeral style for 999
4 =ROMAN(999,1) LMVLIV More concise version for 999
5 =ROMAN(999,2) XMIX More concise version for 999
6 =ROMAN(999,3) VMIV More concise version for 999
7 =ROMAN(999,4) IM Simplified version for 999
8 =ROMAN(999,TRUE) CMXCIX Classic roman numeral style for 999
9 =ROMAN(999,FALSE) IM Simplified version for 999

Common Function Error(s)

Problem What went wrong
#VALUE! Occurs if either:

  the supplied number is < 0 or > 3999, or is not recognized as a number
  the supplied [form] argument is supplied and is not recognized as either 0, 1, 2, 3 4, TRUE or FALSE
The function results in a blank cell Occurs if the number argument is zero (0)