Excel MOD() Function
Excel MOD() Function
The MOD() function in excel returns the remainder after a number is divided by a divisor
Syntax
MOD(number, divisor)
Parameter
Number(required)- This parameter represents the number which you want to divide.
Divisor(required)- This parameter represents the number to divide with.
Category
Math & Trig
Returns
This function returns the remainder after a number is divided by a divisor
Example 1
Objective: Use MOD function on the following examples
| Number | Divisor | Remainder/Result | Formula |
| 13 | 5 | 3 | =MOD(A18,B18) |
| 19 | 2 | 1 | =MOD(A19,B19) |
| 8 | 7 | 1 | =MOD(A20,B20) |
| -28.5 | 6 | 1.5 | =MOD(A21,B21) |
Example 2
Objective: Extract time from date & time stamp given in cell
| Number | Divisor | Remainder/ Result | Formula |
| 31-Mar-2014 13:29 | 1 | 13:29 | =MOD(D127, E127) |