Please note javascript is required for full website functionality.

Blog

A to Z of Excel Functions: The DOLLARFR Function

24 September 2018

Welcome back to our regular A to Z of Excel Functions blog. Today we look at the DOLLARFR function.


The DOLLARFR function

This function is essentially the opposite of the DOLLARDE function – it converts decimal numbers to fractional dollar numbers, such as securities prices.

The DOLLARFR function employs the following syntax to operate:

DOLLARFR(decimal_dollar, fraction)

The DOLLARFR function has the following arguments:

  • decimal_dollar: this is required and represents a decimal number
  • fraction: this is also required. This is the integer to use in the denominator of a fraction.

It should be further noted that:

  • 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.

Please see my example below:

We’ll continue our A to Z of Excel Functions soon. Keep checking back – there’s a new blog post every business day.

A full page of the function articles can be found here.

Newsletter