mod function

[Narend]

Can somebody explain following formula to me,I am a little bit confused?
The MOD function can be expressed in terms of the INT function:

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

Narend

 

[Hui]

That's correct
Mod returns the remainder when the divisor is wholy divided into the main number.
in your example d goes into n, n/d times
so subtracting the integer of that Int(n/d) multiplied by d from n leaves you with the remainder.

A large number of Excel functions can be expressed in terms of other functions.
Ultimately all functions can be broken down into the +, -, * and / functions

 

[Narend]

Thanks sir.