INT vs MOD Function in Excel: What is the Difference? (Easy Guide)

Hello friends! Today I share with you INT and MOD formulas in Excel along with easy examples.

Sometimes you divide a number, and you get decimal (like 10 / 3 = 3.33). INT and MOD are brothers that help you split that result! INT gives you the whole number, and MOD gives you the leftover (remainder). Very easy!

🛠️ How to write INT and MOD

1. INT Function (Integer)

INT removes all the decimals and only keeps the whole number. It always round down.

Syntax:

=INT(number)

2. MOD Function (Modulo)

MOD only gives you the leftover number (remainder) after you divide.

Syntax:

=MOD(number, divisor)

• number: The number you want to divide.
• divisor: The number to divide by.

📊 Short & Clear Example

Imagine you have 10 apples and you want to share with 3 friends.

• INT tells you how many apples each friend get.
• MOD tells you how many apples left for you!

💡 Easy Pro Tips

1. Find Even or Odd: You can use MOD to check if number is Even or Odd! Just type =MOD(A1, 2). If result is 0, it is Even. If result is 1, it is Odd! Very useful.
2. Time Calculation: MOD is very good for calculating time difference across midnight! Example: =MOD(EndTime - StartTime, 1).
3. INT on Negative Number: Be careful! INT always round down. So =INT(-4.3) will become -5, not -4.

📚 Useful Resources

• Int vs Trunc Function in Excel (Video in Khmer)
• How to Use MOD and Math Functions in Excel + Tips
• Round vs Roundup vs Rounddown Function in Excel (Video)