Close the skill gap with the Financial Modeling & Valuation Analyst (FMVA)® Certification >> Enroll today and save!

DOLLARFR Function

Converts a dollar value in decimal notation into a dollar value in fractional notation

What is the DOLLARFR Function?

The DOLLARFR function is a Financial function. DOLLARFR helps in converting a dollar value in decimal notation into a dollar value expressed in fractional notation. The function was introduced in MS Excel 2007.

DOLLARFR is very useful when dealing with financial reports and stock market quotes. Financial analysts often see prices as 1 4/16 or in the form of 1.25; the function will help them convert the figures.

 

Formula

=DOLLARFR(decimal_dollar, fraction)

 

The DOLLARFR function uses the following arguments:

  1. Decimal_dollar (required argument) – It is the dollar value expressed as a decimal number.
  2. Fraction (required argument) – It is the integer to be used in the denominator of a fraction. We need to provide it as an integer but if the decimal value is provided, MS Excel will truncate it to an integer.

 

The function converts the decimal part of the “decimal_dollar” number into a fraction with the denominator being “fraction.”

 

How to use the DOLLARFR Function in Excel?

To understand the uses of the DOLLARFR function, let’s consider a few examples:

 

Example 1

Let’s see how the function works using the examples shown below:

 

DOLLARFR Function

 

As seen above, the DOLLARFR() function takes two arguments: the number and an integer for the denominator.

The results in Excel are shown below:

 

DOLLARFR Function - Example 1

 

Example 2

The DOLLARFR function is also useful to convert non-dollar data. For example, we are given the height of several students and we wish to convert them into decimal. It can be done, as shown below:

 

DOLLARFR Function - Example 2

 

Suppose we sum up the results, we will get the result as 31.26 and find out the average as 5.21. Now, if we wish to know the average in feet and inches, we can apply the DOLLARFR function. The result we will get is 5 feet 3 inches.

 

DOLLARFR Function - Example 2a

 

Few notes about the DOLLARFR Function

  1. If the fraction given is not an integer, it will be truncated.
  2. #NUM! error – Occurs when the fraction is less than zero.
  3. #DIV/0 error – Occurs when the fraction given is zero.
  4. #VALUE! error – Occurs if any of the given argument is non-numeric.
  5. The DOLLARFR function is for display only. We can’t use the value it returns in other calculations or in charts. If we wish to do calculations on such values, we will need to reconvert them into decimal values using the DOLLARDE() function.
  6. The function accepts a reference to a cell so we can provide the arguments in a different cell and refer to them to the DOLLARFR formula.
  7. For users with MS Excel 2003, remember that DOLLARFR function is only available when we the Analysis ToolPak add-in is loaded.

 

Click here to download the sample Excel file

 

Additional resources

Thanks for reading CFI’s guide to important Excel functions! By taking the time to learn and master these functions, you’ll significantly speed up your financial analysis. To learn more, check out these additional resources:

  • Excel Functions for Finance
  • Advanced Excel Formulas Course
  • Advanced Excel Formulas You Must Know
  • Excel Shortcuts for PC and Mac

Free Excel Tutorial

To master the art of Excel, check out CFI’s FREE Excel Crash Course, which teaches you how to become an Excel power user.  Learn the most important formulas, functions, and shortcuts to become confident in your financial analysis.

 

Launch CFI’s Free Excel Course now to take your career to the next level and move up the ladder!