DOLLARDE Function in Google Sheets

Convert a fractional dollar price into a decimal dollar price using the DOLLARDE function.

DOLLARDE Function

The DOLLARDE function in Google Sheets converts a dollar price expressed as a fraction into a decimal format.

Syntax

DOLLARDE(fractional_price, unit)
  • fractional_price: The dollar price expressed as a fraction. This is a required parameter.
  • unit: The denominator used in the fractional price. This is a required parameter.

Examples

  1. Convert Fractional to Decimal

Convert a fractional price of 12 3/8 to a decimal price using 8 as the denominator:

=DOLLARDE(12.375, 8)

This will output 12.375.

Notes

  • The DOLLARDE function is particularly useful in finance, where prices are often quoted in fractional terms.
  • Ensure that the unit accurately reflects the denominator used in the fractional price.
  • DOLLARFR: Convert a decimal dollar price into a fractional dollar price.