Spread Formula Reference
ROMAN
Formula Functions > Functions R to S > ROMAN

This function converts an arabic numeral to a roman numeral text equivalent.

Syntax

ROMAN(number,style)

Arguments

This function has these arguments:

Argument Description
number Arabic number to convert
style Type of roman numeral

Remarks

The style of roman numeral is set by the numeric value of the style argument:

Style value Roman numeral style
0 or omitted Classic
1 More concise
2 More concise
3 More concise
4 Simplified
TRUE Classic
FALSE Simplified

An error is returned if the number argument is negative.

Data Types

Accepts numeric data. Returns string data.

Examples

ROMAN(100,3)

Version Available

This function is available in product version 2.0 or later.

See Also

ABS | Math and Trigonometry Functions