## Excel TRIMMEAN Function:

In this post, you will learn the usage of **Excel TRIMMEAN Function in Office 365** with its syntax, explanation, and examples. Let’s step into this article!! Get an official version of **MS Excel** from the following link: https://www.microsoft.com/en-in/microsoft-365/excel

##
**TRIMMEAN Function – Explanation:**

- This function
**calculates the mean by excluding the percentage of data points from the top & bottom of the data set.** - TRIMMEAN function rounds the number of excluded data points down to the nearest multiple of 2.

## Syntax:

**=TRIMMEAN(array, percent)**

### Arguments Explanation:

**Array – ** The array or range of values to trim and get average.

**Percent – ** The number of data points to be excluded from the calculation. For example, 10 percent of 20 data points is equal to 2 points. So, this function excludes one value from the top & bottom of the data set.

### Note:

- If the percent is
**less than 0 or greater than 1**, then it returns**#NUM!****Error**. - This function ignores the
**Text**,**Logical****values**,**Blank****cells**, and**Special****symbols**.

## Examples:

Let’s see some examples to understand how this function works.

### Example 1:

- In the below screenshot, you can see the
**input****range**in**Column****B**, and its output**TRIMMEAN****value**is displayed in the**cell****D4**.

### Example 2:

- If the percent is
**less than 0 or greater than 1**, then it returns**#NUM!****Error**.

### Example 3:

- This function ignores the
**Text**,**Logical****values**,**Blank****cells**, and**Special****symbols**.

From the above examples, you can clearly understand how to use the **TRIMMEAN** function.

### Video Tutorial:

## Verdict:

In the above article, you can understand the usage of **Excel TRIMMEAN Function in Office 365** with its syntax, explanation, and examples. Kindly, leave your **feedback** in the comment section. Thanks for visiting **Geek Excel.** Keep Learning!!

## Discussion