Spread WinRT Documentation
Spread WinRT Documentation / Formula Reference / Formula Functions / DOLLARDE
In This Topic
    DOLLARDE
    In This Topic

    Summary

    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)

    See Also