SpreadJS 13
SpreadJS Documentation / Formula Reference / Formula Functions / ROMAN
In This Topic
    ROMAN
    In This Topic

    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