The DOLLARFR function

Contents

The DOLLARFR The function has the following arguments:

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

It should be noted at the same time that:

  • And fraction it is not a whole number, is truncated
  • And fraction is less than 0, DOLLARFR return the #ON ONE! error value
  • And fraction it is 0, DOLLARFR return the # DIV / 0! error value.

Please, see my example below:

Subscribe to our Newsletter

We will not send you SPAM mail. We hate it as much as you.

Datapeaker