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