How to Use ROMAN in Google Sheets in 2020?

ROMANFormats a number in Roman numerals.

Sample Usage

ROMAN(499,0)

ROMAN(A2)

Syntax

ROMAN(number, [rule_relaxation])

number – The number to format, between 1 and 3999, inclusive.

rule_relaxation – [ OPTIONAL – 0 by default ] – The degree to which traditional syntax rules may be relaxed, between 0 and 4 inclusive.

0 indicates strict precedence rules, where I may only precede V and X, V may only precede X, X may only precede L and C, L may only precede C, and C may only precede D and M. Therefore ROMAN(499,0) is CDXCIX.

1 indicates a relaxation where V may precede L and C and L may precede D and M. Therefore ROMAN(499,1) is LDVLIV.

2 indicates a further relaxation where I may precede L and C, and X may precede D and M. Therefore ROMAN(499,2) is XDIX.

3 indicates a further relaxation where V may precede D and M. Therefore ROMAN(499,3) is VDIV.

4 indicates a further relaxation where I may precede D and M. Therefore ROMAN(499,4) is ID.