Share via

MOD() formula returns incorrect result

Anonymous
2014-02-12T18:04:55+00:00

Hi there,

I'm working with Excel and trying to do a simple MOD function to divide one cell by another. It's not coming back with an error, but the number is wildly incorrect (the formula being used is supposed to divide 117480 by 41, for example, and it comes up with 15). I've checked the formula and it's using the correct reference cells. Any idea what could be going on? I'll try to get a screenshot of the problem.

Thanks!

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Deleted

    This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.

    Comments have been turned off. Learn more

  2. Anonymous
    2014-02-12T18:23:02+00:00

    MOD() does not divide one number by another. It return the remainder after the two numbers have been divided. QUOTIENT() returns the integer portion of a division formula. With 117,480 in A1 and 41 in A2 try,

    =QUOTIENT(A1,A2)

    ... which returns 2865. The remainder is produced by MOD()

    =MOD(A1,A2)

    ... which returns 15.

    You would have to put them together and do some math like this,

    =QUOTIENT(A1,A2) + MOD(A1,A2)/A2

    to get 2865.365854. Much easier to simply use

    =A1/A2

    QUOTIENT function Returns the integer portion of a division
    MOD function Returns the remainder from division

    Was this answer helpful?

    0 comments