DOLLARFR
Syntax:
DOLLARFR ( decimal-dollar , fraction )
Description: Converts a dollar price expressed as a decimal into a dollar price expressed as a fraction.
Note: : This function is used to convert decimal dollar numbers, such as securities prices, to fractional numbers.
Arguments:
Name |
Type |
Description |
|---|---|---|
decimal-dollar |
number |
The number expressed as a decimal. |
fraction |
number |
The integer to use in the denominator of the fraction. |
Return Type and Value: number – The dollar price expressed as a fractional number.
example: : A result of m.n means m + n/fraction dollars.
However, if
fraction < 0,
#NUM!is returned.fraction = 0,
#DIV/0!is returned.
example: