How do I use MOD in Excel?
Use MOD when you want to return the remainder of a division. Enter Number, Divisor in that order, then add optional arguments when needed.
Excel Function
MOD
Returns remainder after division.
MOD(number, divisor)Arguments
number
RequiredSpecify a single cell reference.
divisor
RequiredEnter a numeric value.
Practice Preview
Use MOD to return the result with these settings (Number: D2 (cell D2 (Amount in column D)), Divisor: 3).
Example Table
| # | ASlip ID | BUnit Price | CQuantity | DAmount |
|---|---|---|---|---|
| 2 | S001 | 120.5 | 3 | 361.5 |
| 3 | S002 | 98.2 | 5 | 491 |
| 4 | S003 | 450.7 | 2 | 901.4 |
| 5 | S004 | 300.4 | 4 | 1201.6 |
| 6 | S005 | 150.9 | 6 | 905.4 |
| 7 | ||||
| 8 |
How to Use (Formula)
=MOD(D2, 3)Result
1.5
Practice This Function
MOD FAQ
Where can I practice MOD?
Use the "Start Function Practice" button to jump straight into MOD drills.
What arguments does MOD use?
The main arguments are Number, Divisor. Enter them in order.