DOLLARDE
Syntax:
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.
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.
|
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: