[Table of Contents] [docx version]
SpreadsheetML Reference Material - Table of Contents
DOLLARDE ( fractional-dollar , fraction )
Description: Converts a dollar price expressed as a fraction into a dollar price expressed as a decimal number. [Note: This function is used to convert fractional dollar numbers, such as securities prices, to decimal numbers. end note]
Arguments:
Name |
Type |
Description |
fractional-dollar |
number |
The number expressed as a fraction. |
fraction |
number |
The integer to use in the denominator of the fraction. [Example: A fractional-dollar value of m.n means m + n/fraction dollars. end example] |
Return Type and Value: number – The dollar price expressed as a decimal number.
However, if
• fraction < 0, #NUM! is returned.
• fraction = 0, #DIV/0! is returned.
[Example:
DOLLARDE(1.02,16) results in 1.125
DOLLARDE(1.1,32) results in 1.3125
end example]