The DOLLARFR function converts a dollar price, expressed as a decimal number, into a dollar price, expressed as a fraction. Fractional dollar numbers are sometimes used for security prices.

DOLLARFR takes 2 required arguments and no optional arguments:

Syntax: DOLLARFR(decimal_dollar, fraction)

#1)
Using the DOLLARFR function:
#2)
The arguments for the DOLLARFR function are:
Argument Required? Description
decimal_dollar Required A decimal number
fraction Required The integer to use in the denominator of the fraction.
#3)
A few more things:
If fraction is not an integer, it is truncated.
If fraction is less than 0, DOLLARFR returns the #NUM! error value.
If fraction is greater than or equal to 0 and less than 1, DOLLARFR returns the #DIV/0! error value.

Summary

The DOLLARFR function converts a dollar price, expressed as a decimal number, into a dollar price, expressed as a fraction.
comments powered by Disqus