Table of Contents
The DOLLARDE function is a powerful tool in Google Sheets that allows users to convert a given dollar amount into a decimal value. To use this function, simply enter the dollar amount in the designated cell and then use the DOLLARDE function to convert it into a decimal value. This function is especially useful for financial calculations and analysis. It is important to note that the DOLLARDE function follows a specific syntax and any errors in the formula may result in incorrect calculations. Overall, the DOLLARDE function is a valuable feature in Google Sheets that simplifies the process of converting dollar amounts into decimal values.
DOLLARDE
Converts a price quotation given as a decimal fraction into a decimal value.
Sample Usage
DOLLARDE(100.10,32)
DOLLARDE(A2,8)
Syntax
DOLLARDE(fractional_price, unit)
fractional_price– The price quotation given using fractional decimal conventions.unit– The units of the fraction, e.g.8for 1/8ths or32for 1/32nds.
Notes
DOLLARDEis used to convert from prices specified on certain securities exchanges with minimal increments (e.g. 1/8 or 1/32) into decimal format. These prices may be transmitted on electronic exchanges as 100.01 for 100 1/8 or 100 1/32 depending on the system and minimal increment.DOLLARDE(100.01,8)results in100.125whereasDOLLARDE(100.01,32)results in100.03125.
See Also
DOLLARFR: Converts a price quotation given as a decimal value into a decimal fraction.
Examples
[wpcc-iframe height=”300″ src=”https://docs.google.com/spreadsheet/pub?key=0As3tAuweYU9QdEtLemhvYlZYSkF5QTVueHRWQ05NWHc&output=html” width=”500″]
Cite this article
stats writer (2024). How do I use the DOLLARDE function in Google Sheets?. PSYCHOLOGICAL SCALES. Retrieved from https://scales.arabpsychology.com/stats/how-do-i-use-the-dollarde-function-in-google-sheets/
stats writer. "How do I use the DOLLARDE function in Google Sheets?." PSYCHOLOGICAL SCALES, 29 Jun. 2024, https://scales.arabpsychology.com/stats/how-do-i-use-the-dollarde-function-in-google-sheets/.
stats writer. "How do I use the DOLLARDE function in Google Sheets?." PSYCHOLOGICAL SCALES, 2024. https://scales.arabpsychology.com/stats/how-do-i-use-the-dollarde-function-in-google-sheets/.
stats writer (2024) 'How do I use the DOLLARDE function in Google Sheets?', PSYCHOLOGICAL SCALES. Available at: https://scales.arabpsychology.com/stats/how-do-i-use-the-dollarde-function-in-google-sheets/.
[1] stats writer, "How do I use the DOLLARDE function in Google Sheets?," PSYCHOLOGICAL SCALES, vol. X, no. Y, ص Z-Z, June, 2024.
stats writer. How do I use the DOLLARDE function in Google Sheets?. PSYCHOLOGICAL SCALES. 2024;vol(issue):pages.