In This Topic

DOLLARFR

In This Topic

This function converts a decimal number dollar price to a fraction dollar price.

DOLLARFR(*decimaldollar*,*fraction*)

This function has these arguments:

Argument | Description |
---|---|

decimaldollar |
Decimal number |

fraction |
Denominator of the fraction; if not an integer, the number is truncated |

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.

Accepts numeric data for both arguments. Returns numeric data.

DOLLARFR(B5,D2)

DOLLARFR(R5C2,R2C4)

DOLLARFR(1.125,16) gives the result 1.02

This function is available in product version 2.0 or later.

DOLLAR | DOLLARDE | Financial Functions