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!