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.
=SUM(DOLLARDE(A1:A3,12)) is not possible.
Instead, you can use:
Syntax for DOLLARDE Function
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:
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.
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.