How do I use the DOLLARDE function in Excel?

How do I use the DOLLARDE function in Excel?

By /

The DOLLARDE function in Excel is a useful tool for converting a dollar value into its decimal equivalent. To use this function, you simply need to enter the dollar amount you want to convert and specify the number of decimal places you want to display. This function can be particularly helpful for financial calculations or when working with currency conversions. By accurately converting dollar values into decimals, the DOLLARDE function allows for more precise and efficient data analysis in Excel.

This article describes the formula syntax and usage of the DOLLARDE function in Microsoft Excel.

Description

Converts a dollar price expressed as an integer part and a fraction part, such as 1.02, into a dollar price expressed as a decimal number. Fractional dollar numbers are sometimes used for security prices.

The fraction part of the value is divided by an integer that you specify. For example, if you want your price to be expressed to a precision of 1/16 of a dollar, you divide the fraction part by 16. In this case, 1.02 represents $1.125 ($1 + 2/16 = $1.125).

Syntax

DOLLARDE(fractional_dollar, fraction)

The DOLLARDE function syntax has the following arguments:

  • Fractional_dollar    Required. A number expressed as an integer part and a fraction part, separated by a decimal symbol.

  • Fraction    Required. The integer to use in the denominator of the fraction.

Remarks

  • If fraction is not an integer, it is truncated.

  • If fraction is less than 0, DOLLARDE returns the #NUM! error value.

  • If fraction is greater than or equal to 0 and less than 1, DOLLARDE returns the #DIV/0! error value.

Cite this article

stats writer (2024). How do I use the DOLLARDE function in Excel?. PSYCHOLOGICAL SCALES. Retrieved from https://scales.arabpsychology.com/stats/how-do-i-use-the-dollarde-function-in-excel/

stats writer. "How do I use the DOLLARDE function in Excel?." PSYCHOLOGICAL SCALES, 29 Jun. 2024, https://scales.arabpsychology.com/stats/how-do-i-use-the-dollarde-function-in-excel/.

stats writer. "How do I use the DOLLARDE function in Excel?." PSYCHOLOGICAL SCALES, 2024. https://scales.arabpsychology.com/stats/how-do-i-use-the-dollarde-function-in-excel/.

stats writer (2024) 'How do I use the DOLLARDE function in Excel?', PSYCHOLOGICAL SCALES. Available at: https://scales.arabpsychology.com/stats/how-do-i-use-the-dollarde-function-in-excel/.

[1] stats writer, "How do I use the DOLLARDE function in Excel?," PSYCHOLOGICAL SCALES, vol. X, no. Y, ص Z-Z, June, 2024.

stats writer. How do I use the DOLLARDE function in Excel?. PSYCHOLOGICAL SCALES. 2024;vol(issue):pages.

Download Post (.PDF)

Related terms:

  1. How do I use the DOLLARDE function in Google Sheets?
  2. How to Dynamically Sum Ranges in Excel Using INDIRECT and SUM
  3. How to Conditionally Extract Text from the Left Side of a Cell in Excel
  4. How can I use the BASE function in excel to perform a specific calculation or function?
  5. How can I use the BESSELI function in Excel to calculate the modified Bessel function?
  6. How can I use the BESSELK function in Excel to calculate the modified Bessel function of the second kind?
  7. What is the function of the COUNTIF function in Excel?
  8. How do I convert a function to a question in Excel using the DOLLAR function?
  9. How can I create a function in Excel that performs the same calculations as the NA function?
  10. How can I use the IF Function with the LEFT Function in Microsoft Excel?
Slide Up
x
PDF
Scroll to Top