Spread.NET 17 Formula Reference
Formula Functions / Functions R to S / 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)

    Version Available

    This function is available in product version 2.0 or later.

    See Also

    ABS | Math and Trigonometry Functions