[Table of Contents] [docx version]
SpreadsheetML Reference Material - Table of Contents
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. end note]
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. end example]
However, if
• fraction < 0, #NUM! is returned.
• fraction = 0, #DIV/0! is returned.
[Example:
DOLLARFR(1.125,16) results in 1.02
DOLLARFR(1.125,32) results in 1.04
end example]