Excel MOD function (division) is not giving correct answer

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

BCtrout - 26 Sep 2004 23:15 GMT

when directing one cell to be divided by anouther cell the answer is
incorrrect.
dividing 56250 by 2 gives me 0 and
dividing 28125.00 by 12 gives me 9

Reply to this Message

garfield-n-odie - 26 Sep 2004 23:53 GMT

What is the exact formula you entered?

> when directing one cell to be divided by anouther cell the answer is
> incorrrect.
> dividing 56250 by 2 gives me 0 and
> dividing 28125.00 by 12 gives me 9

Reply to this Message

Rob Bovey - 27 Sep 2004 00:29 GMT

> when directing one cell to be divided by anouther cell the answer is
> incorrrect.
> dividing 56250 by 2 gives me 0 and
> dividing 28125.00 by 12 gives me 9

The Excel MOD function divides the first number by the second number and
returns the remainder from the division. Therefore the two results above are
the correct output of the MOD function. If you want to divide, use the
division operator:

=56250/2

=28125/12

Signature

Rob Bovey, MCSE, MCSD, Excel MVP
Application Professionals
http://www.appspro.com/

* Please post all replies to this newsgroup *
* I delete all unsolicited e-mail responses *

Reply to this Message