SpreadJS 14
Formula Reference / Formula Functions / Financial Functions / DOLLARFR
In This Topic
    DOLLARFR
    In This Topic

    This function converts a decimal number dollar price to a fraction dollar price.

    Syntax

    DOLLARFR(decimaldollar,fraction)

    Arguments

    This function has these arguments:

    Argument Description
    decimaldollar Decimal number
    fraction Denominator of the fraction; if not an integer, the number is truncated

    Remarks

    If fraction is not an integer, it is truncated. If fraction is less than 0, a #NUM! error is returned. If fraction is 0, a #DIV/0! error is returned.

    Data Types

    Accepts numeric data for both arguments. Returns numeric data.

    Examples

    DOLLARFR(B5,D2)

    DOLLARFR(R5C2,R2C4)

    DOLLARFR(1.125,16) gives the result 1.02

    See Also