Wauvel

Excel like a finance pro.

← The library

Math function

ROMAN

Converts an Arabic number to Roman numerals as text.

Rarely usedDifficulty 1000 · CapableUsage rank #241 of 520
Practice · 2 questions →

When to use it

Converts an Arabic number to Roman numerals as text. The form argument allows progressively more concise, non-classical spellings.

The shape of it

Syntax
=ROMAN(number, [form])

Worked examples

  • A year

    =ROMAN(2024) → MMXXIV

    Classic form.

  • Classic

    =ROMAN(499) → CDXCIX

    Classic subtractive notation.

  • Simplified form

    =ROMAN(499,4) → ID

    Form 4 is the most simplified.

Worth knowing

  • Result is text; it cannot be summed. ARABIC converts back.
  • Only 0 to 3999 are supported.
  • Form 0 (or TRUE) is classic, 4 (or FALSE) is simplified.

Where it goes wrong

  • #VALUE! for numbers above 3999 or negative numbers.
  • ROMAN(0) returns an empty string rather than an error.

Related

SUMSUMIFSUMIFSROUNDABSSUMPRODUCT

Learn the moves here — or let Wauvel run them on your numbers.

Meet your AI CFO →

One CFO-grade Excel tip a week

A short, practical email for finance operators — functions, shortcuts, and the moves that save an afternoon. Free, unsubscribe anytime.