MOD Function in Excel – A Complete Beginner’s Guide

When you divide numbers, you often get two parts —

the quotient (whole number part) and the remainder (what’s left after division).

In Excel, if you want to find only the remainder, you can use the MOD function.

What Is the MOD Function?

The MOD function in Excel gives you the remainder after dividing one number by another.

For example:

When you divide 10 by 3,

 3 fits into 10 three times (3 × 3 = 9),

 and 1 is left over.

So, the remainder (or modulus) is 1.

That’s exactly what MOD shows you in Excel.

Syntax:

=MOD(number, divisor)

•  number → the number you want to divide

•  divisor → the number you divide by

Example:

`=MOD(10, 3)` → 1

Because 10 ÷ 3 = 3 remainder 1.

Number	Divisor	Formula	Result
10	3	=MOD(A2, B2)	1
25	4	=MOD(A3, B3)	1
15	5	=MOD(A4, B4)	0

The MOD function finds what’s left after dividing each number.

Difference Between `/`, QUOTIENT, and MOD:

Method	Formula	Result	Description
Division /	3.33333	3.333	Shows the full decimal result
QUOTIENT	3	3	Shows only the integer part    (whole number)
MOD	1	1	Shows only the remainder

Each method gives a different type of result.

Use the one that fits your need.

MOD + QUOTIENT Together:

You can combine MOD with QUOTIENT to get both the integer and the remainder parts of a division.

Example:

You have 10 apples to share among 3 friends.

`=QUOTIENT(10,3)` → 3 each

`=MOD(10,3)` → 1 left over

So each friend gets 3 apples, and 1 apple remains.

The MOD function is a simple but powerful tool that helps you find what remains after division.

To summarize:

• Use `/` for decimal results,
• Use QUOTIENT for whole numbers,
• Use MOD for remainders.

Together, QUOTIENT and MOD give you full control over division results in Excel.