Spread Formula Reference
DOLLARDE
Formula Functions > Functions D to G > DOLLARDE

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