FormulaCraft

ROMAN

ROMAN converts a positive integer between 1 and 3999 into its Roman numeral representation as a text string. An optional form argument (0–4) controls how classic or simplified the notation is, with 0 being fully classic.

Excel
=ROMAN(A2,0)
Google Sheets
=ROMAN(A2,0)
✓

Verified example

Computed by a real spreadsheet engine on the sample data below.

ChapterRoman
1
4
9
2024

=ROMAN(A2,0)→I

Try it with your data

Edit the grid or formula, then run it through a real spreadsheet engine — no signup.

Sample data — click any cell to edit

Runs server-side · free · no signup

How it works

  1. 1A2 is the integer to convert — must be between 1 and 3999.
  2. 20 is the form argument: 0 = classic Roman numerals, 4 = most simplified.
  3. 3ROMAN(2024,0) returns "MMXXIV".

Need a version for your data?

Try: “Convert chapter numbers to Roman numerals”

Related

SUMIFSUMIFSCOUNTIF

Written and reviewed by FormulaCraft Team. Each formula on this page is run through our verification engine before publishing.

Last reviewed: