## 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!