Lesson#18: What is MOD function?

MOD function returns the remainder after dividing a number with a divisor. Syntax of the function is =MOD(number, divisor). Let me show you an example.

I have typed a random number 123456789 then I will add the MOD function to show the remainder. I am going to divide the number by 100000000.

I have put the formula =MOD(C3, 100000000) which gives the result 23456789.

In my next posts, I will show examples of worksheets where the MOD function shall be very useful.