Filter by Categories
Select all
Business Statements
Federal Income Tax
Gantt Chart
GST India
Health, Logs and Personal Trackers
Invoice/ Bill
Payroll & HR
Project Reports & Timelines
Purchase Order/Requisition
Rental Ledger
Risk Registers
Sales/ Marketing
SWOT Analysis
Timesheet/ Attendance
Filter by File Types

Excel Math Functions : MOD

How to use MOD Math Functions in Microsoft Excel

Introduction to MOD Function

MOD function returns the remainder value after dividing a number with a divisor. In simple words, it returns that value which remains after the division of two numbers.

Download Sample file

Download Sample file for working with the tutorial.

Syntax of MOD Function

MOD(number, divisor)

Arguments in MOD Function

  • number: The number which you want to divide.
  • divisor: The number with which you want to divide


  • It will return a #DIV/0! error if the divisor is zero.

Tutorial of MOD Function in MS Excel

In the below example, we have used MOD with the different types of values:

  1. If there is no remainder after dividing two numbers it returns zero.
  2. If there is a decimal in divisor it considers that decimal and returns result according to that.
  3. If you specify zero to divide, it returns a 0 in the result. Dividing any number by zero results in zero.
  4. If the divisor will zero, it will return #DIV/0!.
  5. If you skip specifying any number for dividing it will return 0 in the result.
  6. And if you skip specifying any divisor, it will return #DIV/0!.
  7. It will consider negative values and return the same sign that the divisor has.

Other Math Function in Microsoft Excel

Explore other math function in Microsoft excel. The list of all the math function available for everyday use is given below –


Macro Codes in Excel

Learn Excel Quickly
Get full list of Excel Macro Codes