DOLLARFR function

The DOLLARFR function in Excel is used to convert a decimal dollar amount into a fractional dollar amount (mixed number). This is helpful when you need to express monetary values in the form of fractions, such as “$1.25” being expressed as “$1 1/4”.

Syntax

DOLLARFR(decimal_dollar, fraction)

Parameters

• decimal_dollar: The decimal dollar amount that you want to convert. This is a number that can be represented as a mixed number, such as 1.25 or 3.5.
• fraction: The denominator of the fraction. This specifies the denominator for the fractional part of the value. For example, if the fraction is expressed in quarters, you would use 4 (for 1/4, 2/4, etc.).

How It Works

The DOLLARFR function converts a decimal number into its fractional equivalent based on the denominator specified. It extracts the whole dollar portion and then converts the fractional part into the corresponding fraction based on the provided denominator.

Formula Explanation

The general formula is:

$$\text{Fractional Dollar Value} = \text{Whole Dollar Part} \ \frac{\text{Numerator of Fraction}}{\text{Fraction Denominator}}$$

For example, if you have 1.25 and you specify a denominator of 4 (quarters), the function converts 0.25 into 1/4 and the result will be “$1 1/4”.

Example

Let’s say you have the following decimal dollar amount:

• $1.75 (which means 1 dollar and three-quarters of a dollar).

You can use the following formula to convert it to a fractional dollar:

=DOLLARFR(1.75, 4)

Explanation of the Example:

• 1.75: This is the decimal dollar amount, which represents 1 dollar and three-quarters (0.75).
• 4: This is the denominator for quarters (since we are working with a fraction of a dollar out of 4).

The DOLLARFR function will return 1 3/4, which is the fractional equivalent of “$1.75”.

Important Notes

• Decimal Dollar Amount: The decimal dollar should be a numerical value where the whole dollar part is followed by the decimal part representing the fraction.
• Denominator: The fraction denominator specifies how fine-grained the fractional part should be. For example:
  • 2 for halves (1/2, 2/2, etc.).
  • 4 for quarters (1/4, 2/4, 3/4, etc.).
  • You can use other denominators like 8, 16, etc., for finer fractions.

Summary

The DOLLARFR function is used to convert a decimal dollar amount into a fractional dollar amount, which is often useful in financial reporting or when dealing with monetary values in fractional terms. It is commonly used in scenarios like checking prices that are expressed in fractional terms or working with financial instruments that require fractional dollars.