The DOLLARDE function in Google Sheets is a powerful tool for converting fractional prices into decimal formats. This function is particularly useful in financial contexts where precision in pricing is essential, streamlining the process of handling fractional currency values accurately and efficiently.

Syntax

DOLLARDE(fractional_dollar, fraction)  
 
fractional_dollar: The number in decimal form representing the dollar amount with fractions.
 
fraction: The denominator that indicates the fraction's precision.
 
 

Example #1

=DOLLARDE(2.5, 8)  

This function converts the price quotation of 2.5 (which stands for 2 5/8 dollars) into a decimal value. The result would be 2.625.

Example #2

=DOLLARDE(11.25, 16)  

Here the function is converting 11.25 (which represents 11 1/4 dollars) into a decimal format. The outcome would be 11.0625.

Example #3

=DOLLARDE(3.75, 4)  

In this instance, the function transforms 3.75 (which denotes 3 3/4 dollars) into a decimal. The result here will be 3.75.

Error handling

• VALUE!: This error occurs when the input for fractional_dollar is not a valid numeric value.
• NUM!: This error is returned if the fraction parameter provided is less than 1 or not a valid denominator.

Conclusion

The DOLLARDE function is a critical capability in Google Sheets for anyone dealing with financial data that involves fractional dollar amounts. By allowing for seamless conversions from fractional formats to decimal values, it enhances data accuracy and simplifies financial analyses. Mastering this function can significantly improve efficiency in financial reporting and assist in maintaining precise accounting standards.