Spread Formula Reference
Formula Functions / Functions D to G / DOLLARDE
In This Topic
    DOLLARDE
    In This Topic

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

    Syntax

    DOLLARDE(fractionaldollar,fraction)

    Arguments

    This function has these arguments:

    Argument Description
    fractionaldollar Numeric value expressed as a fraction
    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

    DOLLARDE(1.10,17)

    DOLLARDE(R5C2,R2C4)

    Version Available

    This function is available in product version 2.0 or later.

    See Also

    DOLLAR | DOLLARFR | Financial Functions