Table of Contents
The DOLLARFR function is a built-in feature in Microsoft Excel that allows users to convert a decimal number into a dollar fraction. This function is useful for financial calculations and budgeting purposes. To use the DOLLARFR function, simply select the cell where you want the result to appear, type “=DOLLARFR(” into the formula bar, then enter the decimal number you want to convert followed by a comma and the desired denominator. Press enter to get the dollar fraction result. This function is easy to use and can save time and avoid errors when dealing with financial data in Excel.
This article describes the formula syntax and usage of the DOLLARFR function in Microsoft Excel.
Description
Use DOLLARFR to convert decimal numbers to fractional dollar numbers, such as securities prices.
Syntax
DOLLARFR(decimal_dollar, fraction)
The DOLLARFR function syntax has the following arguments:
Decimal_dollar Required. A decimal number.
Fraction Required. The integer to use in the denominator of a fraction.
Remarks
If fraction is not an integer, it is truncated.
If fraction is less than 0, DOLLARFR returns the #NUM! error value.
If fraction is 0, DOLLARFR returns the #DIV/0! error value.
Cite this article
stats writer (2024). How do I use the DOLLARFR function in Excel?. PSYCHOLOGICAL SCALES. Retrieved from https://scales.arabpsychology.com/stats/how-do-i-use-the-dollarfr-function-in-excel/
stats writer. "How do I use the DOLLARFR function in Excel?." PSYCHOLOGICAL SCALES, 29 Jun. 2024, https://scales.arabpsychology.com/stats/how-do-i-use-the-dollarfr-function-in-excel/.
stats writer. "How do I use the DOLLARFR function in Excel?." PSYCHOLOGICAL SCALES, 2024. https://scales.arabpsychology.com/stats/how-do-i-use-the-dollarfr-function-in-excel/.
stats writer (2024) 'How do I use the DOLLARFR function in Excel?', PSYCHOLOGICAL SCALES. Available at: https://scales.arabpsychology.com/stats/how-do-i-use-the-dollarfr-function-in-excel/.
[1] stats writer, "How do I use the DOLLARFR function in Excel?," PSYCHOLOGICAL SCALES, vol. X, no. Y, ص Z-Z, June, 2024.
stats writer. How do I use the DOLLARFR function in Excel?. PSYCHOLOGICAL SCALES. 2024;vol(issue):pages.