ROMAN

Syntax:

ROMAN ( number , form )

Description: Converts the Arabic number, number, to a Roman number according to form.

Arguments:

Name

Type

Description

number

number

The Arabic number to be converted.

form

number

Specifies the type of Roman numeral to be produced. The Roman numeral style ranges from Classic to Simplified, becoming more concise as the value of form increases, as follows:

Value

Type

0, omitted, or TRUE

Classic. Only subtract powers of ten (but not L or V). Do not subtract a number from one that is more than 10 times greater. If another letter follows the larger one, it must be smaller than the number preceding the larger one.

1

Concise. Allow subtractraction of L and V as well as powers of ten. Do not subtract a number from one that is more than 10 times greater. If another letter follows the larger one, it must be smaller than the number preceding the larger one.

2

More concise. Allow subtractraction of L (but not V) as well as powers of ten. Allow subtraction of a number from one that is more than 10 times greater. If another letter follows the larger one, it must be smaller than the number preceding the larger one.

3

Most concise. Allow subtractraction of L and V as well as powers of ten. Allow subtraction of a number from one that is more than 10 times greater. If another letter follows the larger one, it must be smaller than the number preceding the larger one.

4 or FALSE

Simplified. Produce the fewest Roman digits.

Return Type and Value: text – The corresponding Roman number.

However, if

  • number < 0 or > 3999, #VALUE! is returned.

  • form is not one of the values listed above, #VALUE! is returned.

example: