Filter by Categories
Select all
Budget
Business Statements
Calendars
Federal Income Tax
Gantt Chart
GST India
Health, Logs and Personal Trackers
Inventory
Investments
Invoice/ Bill
Maintenance
Payroll & HR
Project Reports & Timelines
Purchase Order/Requisition
Quotation
Rental Ledger
Risk Registers
Sales/ Marketing
SWOT Analysis
Timesheet/ Attendance
UAE VAT
UK VAT
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

Notes

  • 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 –

Content

Macro Codes in Excel

Learn Excel Quickly
Get full list of Excel Macro Codes