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

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