• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

mod fun

N

Narend

Member
can anybody explain this below mentioned formula with example and where we use this?

MOD(n, d) = n - d*INT(n/d)

Truly yours

Narend
 
Hi Narend ,

This is not a formula ; this is the mathematics behind the MOD ( modulo ) function.

The modulo function returns the remainder when one number is divided by another ; for instance , when we divide the number 11 by 7 , the remainder is 4.

Thus MOD(11,7) will return 4.

In case the MOD function is not available , you can get the same result by :

11 - 7 * INT(11/7)

The INT function returns the integer quotient when one number is divided by another ; in this case , when you divide 11 by 7 , the integer quotient is 1.

Thus 11 - 7 * 1 = 11 - 7 = 4.

Narayan
 
You must log in or register to reply here.
Back
Top