loading...

How to Use Excel TRIMMEAN Function in Office 365? – {with Examples}

excelgeek profile image Andrews Originally published at geekexcel.com on ・3 min read

Excel TRIMMEAN Function:

TRIMMEAN Function
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 1
Example 1

Example 2:

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

Example 2
Example 2

Example 3:

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

Example 3
Example 3

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

See Also:

Posted on by:

excelgeek profile

Andrews

@excelgeek

Founder of Geek Excel!! Blog for Excel Tutorials

Discussion

pic
Editor guide