Find The Remainder When Dividing With Excel S Mod Function

MOD Function Syntax and Arguments

A function’s syntax refers to the layout of the function and includes the function’s name, brackets, and arguments. The syntax for the MOD function is: Number is the number being divided and Divisor is the number by which you want to divide the Number argument. The Number argument can be a number entered directly into the function or a cell reference to the location of the data in a worksheet. The MOD function returns the #DIV/0! error value for the following conditions:

If a zero is entered for the Divisor argument.If a cell reference to a blank cell is entered for the Divisor argument.

Use Excel’s MOD Function

Enter data into the cells. To follow along with this tutorial, enter 5 in cell D1 and enter 2 in cell D2. Since the MOD function only returns the remainder, the integer portion of the division operation (2) is not displayed. To show the integer as part of the answer, use the QUOTIENT function.