A to Z of Excel Functions: The DOLLARFR Function

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:

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.