Spread Formula Reference
Formula Functions / Functions D to G / 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

    Version Available

    This function is available in product version 2.0 or later.

    See Also

    DOLLAR | DOLLARDE | Financial Functions