mode
| Number | Divisor | Remainder | |
| 12 | 5 | 2 | =MOD(C4,D4) |
| 20 | 7 | 6 | =MOD(C5,D5) |
| 18 | 3 | 0 | =MOD(C6,D6) |
| 9 | 2 | 1 | =MOD(C7,D7) |
| 24 | 7 | 3 | =MOD(C8,D8) |
What Does It Do ?
This function calculates the remainder after a number has been divided by another number.
Syntax
=MOD(Number,Divisor)
Formatting
No special formatting is needed.
Example:
The following table shows garments sold in a clothes shop.
The shopkeeper wants to keep track of the most commonly sold size.
The =MODE() function has been used to calulate this.
| Order | Garmet | Size |
| 001 | Blouse | 10 |
| 002 | Skirt | 10 |
| 003 | Shirt | 8 |
| 004 | Blouse | 10 |
| 005 | Skirt | 12 |
| 006 | Dress | 8 |
| 007 | Shirt | 10 |
| 008 | Blouse | 10 |
| 009 | Dress | 8 |
| 010 | Shirt | 10 |
| 011 | Dress | 12 |
| 012 | Skirt | 12 |
| 013 | Skirt | 10 |
| 014 | Shirt | 10 |
| 015 | Dress | 8 |
| 016 | Shirt | 10 |
| 017 | Blouse | 10 |
| 018 | Blouse | 8 |
| 019 | Dress | 10 |
| 020 | Skirt | 8 |
| Most frequently ordered size : | 10 |
| =MODE(D33:D52) |
| Count of size 8 : | 6 |
| =COUNTIF(D33:D52,”8″) |
| Count of size 10 : | 11 |
| =COUNTIF(D33:D52,”10″) |
| Count of size 12 : | 3 |
| =COUNTIF(D33:D52,”12″) |
Note
If the =AVERAGE() function had been used the answer would have been :
This figure is of no benefit to the shopkeeper as there are no garmets of this size!