mod

 The MOD function in Excel is used to find the remainder after a number is divided by a divisor. The syntax is:

Copy

=MOD(number, divisor)

Here are 10 examples of how you can use the MOD function in Excel, including data and formulas:

---

Example 1: Basic MOD Function

Data:

• Number: 10

• Divisor: 3

Formula:

Copy

=MOD(10, 3)

Result:

Copy

1

(Because 10 ÷ 3 = 3 with a remainder of 1)

---

Example 2: MOD with Negative Number

Data:

• Number: -10

• Divisor: 3

Formula:

Copy

=MOD(-10, 3)

Result:

Copy

2

(Because -10 ÷ 3 = -4 with a remainder of 2)

---

Example 3: MOD with Decimal Number

Data:

• Number: 10.5

• Divisor: 3

Formula:

Copy

=MOD(10.5, 3)

Result:

Copy

1.5

(Because 10.5 ÷ 3 = 3 with a remainder of 1.5)

---

Example 4: MOD with Zero Divisor

Data:

• Number: 10

• Divisor: 0

Formula:

Copy

=MOD(10, 0)

Result:

Copy

#DIV/0!

(Error because division by zero is not allowed)

---

Example 5: MOD to Check Even or Odd

Data:

• Number: 7

Formula:

Copy

=IF(MOD(7, 2) = 0, "Even", "Odd")

Result:

Copy

Odd

(Because 7 ÷ 2 leaves a remainder of 1)

---

Example 6: MOD to Extract Time Component

Data:

• Time Value: 3.75 (3 hours and 45 minutes in decimal)

Formula:

Copy

=MOD(3.75, 1)

Result:

Copy

0.75

(Extracts the fractional part, which represents 45 minutes)

---

Example 7: MOD to Create Repeating Patterns

Data:

• Row Numbers: 1, 2, 3, 4, 5, 6, 7, 8, 9, 10

Formula:

Copy

=MOD(A1, 3)

(Assuming A1 contains the row number)

Result:

Copy

1, 2, 0, 1, 2, 0, 1, 2, 0, 1

(Creates a repeating pattern of 1, 2, 0)

---

Example 8: MOD to Calculate Leap Year

Data:

• Year: 2024

Formula:

Copy

=IF(OR(MOD(2024, 400) = 0, AND(MOD(2024, 4) = 0, MOD(2024, 100) <> 0)), "Leap Year", "Not Leap Year")

Result:

Copy

Leap Year

(Because 2024 is divisible by 4 and not divisible by 100)

---

Example 9: MOD to Group Data into Buckets

Data:

• Values: 12, 25, 37, 48, 50

Formula:

Copy

=MOD(A1, 10)

(Assuming A1 contains the value)

Result:

Copy

2, 5, 7, 8, 0

(Groups values into buckets based on the last digit)

---

Example 10: MOD to Calculate Alternating Row Colors

Data:

• Row Numbers: 1, 2, 3, 4, 5, 6, 7, 8, 9, 10

Formula:

Copy

=IF(MOD(ROW(), 2) = 0, "Color1", "Color2")

Result:

Copy

Color2, Color1, Color2, Color1, Color2, Color1, Color2, Color1, Color2, Color1

(Alternates row colors for better readability)

---

These examples demonstrate the versatility of the MOD function in Excel for various calculations and data manipulations