DOLLARDE Function converts a dollar value in fractional notation a decimal.
The DOLLARDE function is an inbuilt function in Excel. It is in the category of Financial Functions.
It is used as a worksheet function. You can enter the DOLLARDE Function as part of a formula in a cell of a worksheet.
Fractional dollar numbers are mostly used for stocks and security prices. The fraction part of the value is divided by an integer that you specify.
You cannot use any of the DOLLAR functions in array formulas. Thus, you cannot convert a series of fractional values in one formula.
For Example:
=SUM(DOLLARDE(A1:A3,12)) is not possible.
Instead, you can use:
=SUM(DOLLARDE(A1,12),DOLLARDE(A2,12),DOLLARDE(A3,12))
Syntax for DOLLARDE Function
=DOLLARDE(fractional_dollar, fraction)
Arguments
Fractional_dollar: A number expressed as an integer and a fraction part, separated by a decimal.
Fraction: The denominator for the fractional_dollar value. It should be supplied as an integer. If a decimal value is supplied then Excel truncates this to an integer.
We have created the infographics for the DOLLARDE Function. With the help of these infographics, you can easily learn step by step process for using this excel functions.
Furthermore, Excel consists of many inbuilt functions which are helpful in the analytical and statistical study of number.
Simply follow the instructions in the infographics below:
Errors
The DOLLARDE Function returns the #NUM! error when the fraction is less than 0.
The function returns the #DIV/0! error when the fraction is greater than or equal to 0 and less than 1.
DOLLARDE returns the #VALUE! error when either of the specified arguments is non-numeric.
To learn other function like CUMPRINC, ACCRINTM and PRODUCT Functions, please click on the name of the function.
Additionally, you can download other accounting templates like Weekly Timesheet, Salary Sheet and Checkbook Register from here.
We thank our readers for liking, sharing and following us on different social media platforms.
If you have any queries please share in the comment section below. I will be more than happy to assist you.
Leave a Reply