SheetFX
≡
<< Go back to all functions

MOD

The MOD function in Google Sheets returns the result of the modulo operator, which is the remainder after a division operation.

Function Syntax and Parameters

Syntax: MOD(dividend, divisor)

Parameters:

  • dividend: The number to be divided.
  • divisor: The number that divides the dividend.

Step-by-Step Tutorial

  1. Using MOD with two numbers:

    • Example: =MOD(12, 5)
    • Result: 2

  2. Using MOD with cell references:

    • Example: If cell A1 has the value 25 and cell B1 has the value 6, then =MOD(A1, B1) will return 1.

Use Cases and Scenarios

  1. Time Calculation: Determine the remaining minutes after a given time has passed.
  2. Inventory Management: Calculate the quantity remaining after a certain number of items are sold.
  3. Data Analysis: Determine the position of an element in a repeating pattern.

Related Functions

  • QUOTIENT: Returns only the integer part of a division operation.
  • ROUND: Rounds a number to a specified number of decimal places.

Related Articles