Navigation:  Formula Reference > Spreadsheet Formula Functions >

DOLLARDE

Previous pageReturn to chapter overviewNext page

 

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

DOLLAR

DOLLARFR