Navigation:  Formula Reference > Spreadsheet Formula Functions >

ROMAN

Previous pageReturn to chapter overviewNext page

 

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)

 

See Also

ABS