The DOLLARFR function is used to convert a dollar price expressed as a decimal number into a fraction representation. This function is handy when dealing with financial calculations that require fractional representations of dollar prices.


=DOLLARFR(decimal_dollar, fraction)

decimal_dollar The dollar price expressed as a decimal number that you want to convert to a fraction.
fraction The denominator for the fraction representing the dollar price. Typically this is 32 or 64.


When you need to work with dollar prices in a fractional format in Excel, the DOLLARFR function comes to the rescue. It simplifies the process of converting decimal dollar values into fractional representations, which can be crucial in financial analysis or any scenario where precise fractional dollar values are required. This function offers convenience and accuracy when dealing with dollar price calculations that necessitate a fractional perspective, making it a valuable asset for financial professionals and enthusiasts alike.


Suppose you have a stock price of $59.375 that you want to represent as a fraction with a denominator of 8. The DOLLARFR formula would be: =DOLLARFR(59.375, 8) This will return the price as a fraction in the form of 59 3/8.

Imagine you are working with a bond value of $1,012.50 and you wish to express it as a fraction with a denominator of 16. The DOLLARFR formula for this scenario would be: =DOLLARFR(1012.50, 16) This will give the bond value as a fraction like 1012 8/16.


Why use the DOLLARFR function instead of manually converting decimal dollars to fractions?

The DOLLARFR function streamlines the process and ensures accuracy when converting decimal dollar values to fractions. In scenarios where precision and efficiency are crucial, relying on the DOLLARFR function saves time and minimizes human error.

Can the DOLLARFR function handle decimal dollar values with any number of decimal places?

Yes, the DOLLARFR function can convert decimal dollar values with any number of decimal places into fractions as long as the provided values are within Excel's calculation capabilities.

What happens if I use a fraction denominator that is not a standard financial convention, like 16?

While the standard fraction denominators often used in finance are 32 and 64, you can still use non-standard denominators like 16 with the DOLLARFR function. However, it's important to be mindful of industry practices and conventions when choosing the denominator for proper communication and interpretation of fractional dollar values.

Related functions