Pinterest Pixel

MEDIAN Formula in Excel

  What does it do? Gets the middle number in the set of numbers Formula breakdown: =MEDIAN(number1,... read more

Download Excel Workbook
Bryan
Posted on

Steps To Follow

Overview

 

What does it do?

Gets the middle number in the set of numbers

Formula breakdown:

=MEDIAN(number1, [number2], …)

What it means:

=MEDIAN(first number, [succeeding numbers in the set], …)


You have a list of values and you want to get the median or middle of those values. Excel’s MEDIAN Formula can easily get that for you!

An important think to note though, if it’s an odd number of values, it will simply get the middle value. But if it’s an even number of values, it will get the 2 middle values, then get their average!

I explain how you can do this below:

MEDIAN Formula in Excel | MyExcelOnline

Download excel workbookMEDIAN-FORMULA.xlsx

STEP 1: We need to enter the MEDIAN function in a blank cell:

=MEDIAN(

MEDIAN Formula in Excel

 

STEP 2: The MEDIAN arguments:

number1, [number2], …

What is the range of values?

Select the cells containing your values:

=MEDIAN(C9:C12)

MEDIAN Formula in Excel

You now have your median! It is calculated as the average of the 2 middle values since we have an even number of values: (60 + 89) / 2 = 74.50

See also  CHOOSE Formula in Excel

MEDIAN Formula in Excel

 

How to Use the MEDIAN Formula in Excel

 

MEDIAN Formula in Excel | MyExcelOnline

 

If you like this Excel tip, please share itEmail this to someone

email

Pin on Pinterest

Pinterest

Share on Facebook

Facebook

Tweet about this on Twitter

Twitter

Share on LinkedIn

Linkedin

MEDIAN Formula in Excel | MyExcelOnline
Bryan

Bryan is a best-selling book author of the 101 Excel Series paperback books.

Get Video Training

Advance your Microsoft Excel & Office Skills with the MyExcelOnline Academy!

Dramatically Reduce Repetition, Stress, and Overtime!
Exponentially Increase Your Chances of a Promotion, Pay Raise or New Job!

Learn in as little as 5 minutes a day or on your schedule.

Learn More!