Please note javascript is required for full website functionality.
MVP

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