ROMAN Function in Apple Numbers: Syntax, Examples, and Troubleshooting

ROMAN is useful for labeled chapters, outlines, clock faces, exercise numbers, and educational worksheets. Apple’s ROMAN reference defines the numeric input interval as 0 to 3999 and documents five notation styles. Conversion does not produce a number for arithmetic; it produces a Roman-numeral representation. Apple’s checked page does not show precisely what ROMAN(0) outputs, even though zero is inside the documented numeric argument range; do not promise an empty string or error for zero without native testing.

=ROMAN(arabic-num, roman-style)

Argument: arabic-num

Required?
Yes

Type and limits
Number value, from 0 to 3999

Documented behaviour
The number to be represented with Roman numerals.

Argument: roman-style

Required?
No

Type and limits
Modal value: 0, 1, 2, 3, 4 or supported logical synonyms for 0 and 4

Documented behaviour
Omitted / 0 / TRUE selects strict classical style. 4 / FALSE gives the most relaxed style.

The argument order matters: ROMAN(12,0) is a strict-format conversion of twelve, not twelve conversions of zero. Apple’s syntax diagram omits square brackets but its definition explicitly says optional for roman-style.

Style choices: exactly what Apple’s own examples demonstrate

Using the same numeric input of 999, Apple’s documentation lists these outputs:

Style argument: omitted, 0 or `TRUE

Interpretation in Apple
Strict

Formula
=ROMAN(999)

Apple’s documented result
CMXCIX

Style argument: 1

Interpretation in Apple
One degree more relaxed

Formula
=ROMAN(999,1)

Apple’s documented result
LMVLIV

Style argument: 2

Interpretation in Apple
Two degrees more relaxed

Formula
=ROMAN(999,2)

Apple’s documented result
XMIX

Style argument: 3

Interpretation in Apple
Three degrees more relaxed

Formula
=ROMAN(999,3)

Apple’s documented result
VMIV

Style argument: 4orFALSE

Interpretation in Apple
Most relaxed

Formula
=ROMAN(999,4)

Apple’s documented result
IM (Apple explains this representation for style 4)

The final example is inferred from Apple’s explicit style-4 example text, rather than a recorded execution of the literal ROMAN(999,4) formula. Do not assume all styles make the same Roman numeral.

Create a Roman Numerals Lab table. In column A add Arabic-number inputs, and in column B enter the formulas shown. The first five strict-style expected results use classical numerals; the value of 12 and 999 are also explicit Apple examples.

Input cell: A2

Value
1

Formula in B cell
=ROMAN(A2)

Expected text (independently checked, unless noted)
I

Input cell: A3

Value
4

Formula in B cell
=ROMAN(A3)

Expected text (independently checked, unless noted)
IV

Input cell: A4

Value
12

Formula in B cell
=ROMAN(A4)

Expected text (independently checked, unless noted)
XII — also Apple’s example

Input cell: A5

Value
49

Formula in B cell
=ROMAN(A5)

Expected text (independently checked, unless noted)
XLIX

Input cell: A6

Value
999

Formula in B cell
=ROMAN(A6)

Expected text (independently checked, unless noted)
CMXCIX — also Apple’s example

Input cell: A7

Value
2026

Formula in B cell
=ROMAN(A7)

Expected text (independently checked, unless noted)
MMXXVI

Input cell: A8

Value
3999

Formula in B cell
=ROMAN(A8)

Expected text (independently checked, unless noted)
MMMCMXCIX

Independent calculation: a classical greedy Roman-numeral converter using the subtractive pairs CM, CD, XC, XL, IX, IV returned each expected strict-style value. Documentation check: Apple’s published examples agree for 12 and 999. Not native validation: no formula was executed in Numbers. The 3999 and 2026 examples are independently calculated expected outputs, not Apple-observed screen results.

Advanced: configurable style selected by a cell

Put 999 into D2 and 0 into E2 in the same table. In F2 enter =ROMAN(D2,E2) and compare to =ROMAN(999) (expect CMXCIX from Apple’s example). Change E2 to 1, 2, 3, and 4; consult the documented 999-style table above to compare the expected strings. This intentionally uses two input cells, so the reader can identify a wrong style setting instead of diagnosing a literal formula.

Advanced: chapter labels

Enter chapter numbers 1 through 5 in column H. In I2 type =ROMAN(H2) and fill down to I6. Expected labels are I, II, III, IV, V. If you want literal text such as Chapter IV, ="Chapter "&ROMAN(H5) is a common string-composition pattern; native text-concatenation testing remains pending, so the composed output is an expectation, not a Numbers observation.

Situation	Safe response / limitation	Evidence basis
arabic-num is below 0 or above 3999	Reject this example for documentation-based work: outside Apple’s stated input range.	Official range; exact error string not documented.
roman-style omitted	Strict representation is the documented default.	Official style definitions.
Input is 0	Apple’s stated range includes zero but the expected text/error is not explicitly documented; must test in Numbers.	Explicit scope uncertainty.
Numeric input has a decimal fraction	Fractional-input truncation/rounding is not specified by Apple’s checked page; native-test before teaching it.	Official page lacks rule.
roman-style is 5 or an unsupported text token	Use a documented value 0–4 or logical synonym.	Official style menu; exact error handling untested.
Style 1–4 differs from classical notation	That’s intentional; set omitted / 0 / TRUE when strict notation is desired.	Official Apple examples for 999.
You need numeric sorting or totals	Keep the Arabic number in a separate column. The Roman representation is a label, not a numeric key.	Type/semantic explanation, not observed coercion testing.

Excel ROMAN and Google Sheets ROMAN implement related conversions and notation styles. Do not assume all three apps have identical behaviour at zero or for fractions. Google Sheets’ published number-range description differs at zero from Apple’s 0–3999 statement. The normal strict examples are mathematically comparable; no native app-to-app output comparison was performed.

Related official help

For selecting multiple outputs by an index, see Apple’s CHOOSE help. For general numeric functions, consult Apple’s Numeric functions list. These links were checked for intended topic and are not claims of published internal site URLs.

The examples above use Apple’s English-help convention: a comma separates function arguments and a dot denotes a decimal fraction. Apple’s Functions overview says that a semicolon replaces the argument comma when the decimal separator is a comma. For example, a localized two-argument formula uses ;. Function names remain unchanged; display of numeric results depends on document settings. Refer to Apple’s cell-reference instructions when formulas cross tables; the plain B2 examples here intentionally assume all referenced cells are in the same table. Do not copy B2 from one table into another and assume it still points at the intended source.

• Official Apple ROMAN reference, Functions Help 15.4 — checked 2026-10-12.
• Apple Functions overview: required/optional tokens and separators — checked 2026-10-12.
• Apple: refer to cells in formulas — checked 2026-10-12.
• Apple: review formula errors and best practices — checked 2026-10-12.
• Compatibility reference: Microsoft Excel and Google Sheets. These are reference links, not Apple behavioural guarantees.

For a software-specific comparison: LibreOffice Calc ROMAN, Apache OpenOffice Calc ROMAN, Gnumeric ROMAN. A shared name does not establish identical argument, error or version behaviour.

The linked official function documentation was reviewed on October 12, 2026. Apple’s Formulas and Functions Help 15.4 identifies the documentation edition, not a minimum Numbers release or a guarantee of historical platform parity. Selected worked examples were checked using independent mathematical or text-processing models; results are expected values, not observations from the spreadsheet application. Native Apple Numbers execution was not performed. Undocumented coercion, exact error messages and platform-specific behaviour remain unverified.

View reproducible example inputs and independent check results. This record is not a native spreadsheet test log.