**Note**: As of Excel 2010, the MODE function has been replaced by the MODE.SNGL and MODE.MULT functions.

The mode, which is the most frequently occurring value in a list of numbers, is usually considered, along with the mean and median, to be a measure of the average value for that list.

Using the MODE function in Excel makes it easy to find the value that occurs most often.

### The MODE Function's Syntax and Arguments

A function's syntax refers to the layout of the function and includes the function's name, brackets, and arguments.

The syntax for the MODE function is:

**= MODE ( Number1, Number2, ... Number255 )**

Number - (required) the values (to a maximum of 255) for which you want to calculate the mode. This argument can contain the actual numbers - separated by commas - or it can be a cell reference to the location of the data in the worksheet.

**Example Using Excel's MODE Function:**

- Enter the following data into cells D1 to D6: 98, 135, 147, 135, 98, 135

- Click on cell E1 - the location where the results will be displayed

- Click on the
*Formulas*tab

- Choose
**More Functions > Statistical**from the ribbon to open the function drop down list

- Click on
*MODE*in the list to open the function's dialog box

- Highlight cells D1 to D6 in the worksheet to enter the range into the dialog box

- Click OK to complete the function and close the dialog box

- The answer 135 should appear in cell E1 since this number appears the most (three times) in the list of data

- When you click on cell E1 the complete function
**= MODE ( D1 : D6 )**appears in the formula bar above the worksheet

**Note:** If the selected data range contains no duplicate data, the MODE function will return a #N/A error.