DOLLARFR Function in Google Sheets

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

DOLLARFR Function

The DOLLARFR function in Google Sheets converts a dollar price expressed as a decimal into a fractional format.

Syntax

DOLLARFR(decimal_price, unit)
  • decimal_price: The dollar price expressed as a decimal. This is a required parameter.
  • unit: The denominator used in the fractional price. This is a required parameter.

Examples

  1. Convert Decimal to Fractional

Convert a decimal price of 12.375 to a fractional price using 8 as the denominator:

=DOLLARFR(12.375, 8)

This will output 12 3/8.

Notes

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