MEDIAN Function: Microsoft Excel is a powerful data visualization and analysis program used all around the world. It uses spreadsheets to store, organize, or perform operations with formulas and functions. When you handle a set of values and want to find the middle value from them, you can use the MEDIAN function.
In this tutorial, we will guide you to learn how to use Excel MEDIAN Function with its syntax, description, and examples. Get an official version of MS Excel from the following link:
Description of MEDIAN Function
- It is one of the built-in functions in Microsoft Excel.
- This function returns the median (middle number) from the given set of input numbers.
- For example, =MEDIAN(10,20,30,40,50) returns the output median number 30.
- Here, you will see the syntax of the MEDIAN function.
- To apply this function on your spreadsheet, you must select a cell and enter the formula in the following format.
- Once you enter the formula, click the Enter button to get the result.
=MEDIAN(number1, [number2], …)
- Number1 – It is the first input number or cell reference.
- Number2 – It is an optional one. It can be a number or cell reference.
1) This function ignores Empty cells, logical values, and Text, any Non-numerical characters.
2) If all the given input numbers are odd, this function can calculate the middle number from the given set of input numbers.
3) If all the given input numbers are even, the median is calculated as the average of two numbers in the middle.
4) You can give input numbers up to 255 arguments in this function.
Here we come up with a set of examples to make you understand how to apply the MEDIAN function in the Excel worksheet.
- Initially, you must open your Excel workbook on your PC and launch the worksheet with data.
- For instance, we have given the input values in the range B3:E6. And we will get the middle value from the range using the MEDIAN function.
- Then, you must enter the formula in the cell below to get the result.
- After entering the formula, you need to click the Enter button to get the output.
- Once you get the output for the first cell, then you need to drag down the cell to fill in the remaining values.
- This function ignores Empty cells, logical values, and Text, any Non-numerical characters.
From the above example, you can clearly see that the MEDIAN Function ignores the empty cells, logical values, non-numerical values, and text & calculate the middle number of given input and prints the output in the desired cells.
In this post, you can clearly learn the usage of Excel MEDIAN Function with its syntax, description, and examples. Drop your feedback in the comment section. To learn more about Excel functions, then visit our webpage, Aawexcel.com.
You can use the following video to know how to apply the Excel MEDIAN function in the worksheet.
- How to Use Excel FLOOR.MATH Function?
- How to Use Excel FLOOR Function?
- How to Use Excel CEILING.PRECISE Function?
- How to Use Excel CEILING Function?
- How to Use Excel GCD Function?
Hi there, I’m Sridhar – an Excel enthusiast with over 10 years of experience working with software. I’m passionate about using Excel to solve complex problems and streamline business processes. Over the years, I have helped businesses of all sizes to improve their operations and save time and money.
Aside from working with Excel, I also enjoy writing and sharing my knowledge with others. You’ll often find me contributing to the AAW Excel blog, where I provide tips, tricks, and tutorials that are easy to understand for readers of all skill levels.