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