MOD Function in Excel

In this post, you will learn about a simple division formula in Excel – MOD Function, how to use it in your excel spreadsheets.

MOD Function in Excel

This function returns the remainder of two numbers after division.

Syntax

=MOD(number, divisor)

The syntax has two arguments

  • number – This argument holds the number to be divided.
  • divisor – This argument holds the divisor.

You need both arguments to perform the function.

How to use MOD Function in Excel?

The function returns the remainder of two numbers after division.

To start, enter the numbers and the divisors in the excel spreadsheet.

How to use MOD Function in Excel?

In a new cell enter the syntax and highlight the data to include them in the syntax.

How to use MOD Function in Excel?

Press enter to display the answer and use the fill handle to apply the formula to the rest of the data.

MOD Function in Excel

Additional Points:

  • In this excel formula, you can use integers and decimal numbers.
  • When you use a negative number for the divisor, the answer will have the same sign as the divisor.
  • The sign of the number argument does not affect the sign of the answer.
How to use MOD Function in Excel?

Leave A Reply

Your email address will not be published. Required fields are marked *

You May Also Like

In this article, you will learn about the SKEW.P function, the formula syntax and usage of the function in Microsoft...
In this article, you will learn about the SKEW function, the formula syntax and usage of the function in Microsoft...
In this article, you will learn about the RANK.EQ function, the formula syntax and usage of the function in Microsoft...
  • Excel
  • November 23, 2021