Expand Minimize

WorksheetFunction.Roman Method (Excel)

Converts an arabic numeral to roman, as text.

expression .Roman(Arg1, Arg2)

expression A variable that represents a WorksheetFunction object.

Parameters

Name

Required/Optional

Data Type

Description

Arg1

Required

Double

Number - the Arabic numeral you want converted.

Arg2

Optional

Variant

Form - a number specifying the type of roman numeral you want. The roman numeral style ranges from Classic to Simplified, becoming more concise as the value of form increases.

Return Value

String

Form

Type

0 or omitted

Classic.

1

More concise. See example below.

2

More concise. See example below.

3

More concise. See example below.

4

Simplified.

TRUE

Classic.

FALSE

Simplified.

  • If number is negative, the #VALUE! error value is returned.

  • If number is greater than 3999, the #VALUE! error value is returned.

Show:
© 2014 Microsoft