Microsoft Office Tutorials and References
In Depth Information
DOLLARDE
Figure 6.15
The DISC function
returns the security
discount rate.
A
This function is
generated by
cell referencing
DOLLARDE
DOLLARDE converts a fraction dollar price into a decimal dollar price.
=DOLLARDE(fractional_dollar,fraction)
The DOLLARDE function converts the dollar price expressed as a fraction of a dollar. This function is
found only if the Analysis Toolpak is installed. It must be turned on using the Add-Ins command
from the Tools menu.
Is the number expressed as a fraction?
FRACTIONAL_DOLLAR
Is the integer in the denominator of the fraction to be used?
FRACTION
For example: =DOLLARDE(1.35,6) returns the result 1.58.
DOLLARFR
DOLLARFR converts a decimal dollar price into a fraction dollar price.
=DOLLARFR(decimal_dollar,fraction)
The DOLLARFR function converts the dollar price expressed as a decimal to a dollar price
expressed as a fraction. The DOLLARDE function is found only if the Analysis Toolpak is
installed. It must be turned on using the Add-Ins command from the Tools menu.
A decimal number.
DECIMAL_DOLLAR
The integer in the demonimator of the fraction to be used.
FRACTION
For example: =DOLLARFR (1.35,6) returns the result 1.21.
Search JabSto ::




Custom Search