Excel MOD function (division) is not giving correct answer

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
BCtrout said:
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

--
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 *
 
Back
Top