ExcelBanter - What is the Formula to find the Media of a number of cells?

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - What is the Formula to find the Media of a number of cells? (https://www.excelbanter.com/excel-worksheet-functions/61074-what-formula-find-media-number-cells.html)

formula to find the media between cells

What is the Formula to find the Media of a number of cells?

if i wanted to find the median between the cells B4:B15, what would i type
for the formula?

David Billigmeier

What is the Formula to find the Media of a number of cells?

=MEDIAN(B4:B15)

--
Regards,
Dave

"formula to find the media between cells" wrote:

if i wanted to find the median between the cells B4:B15, what would i type
for the formula?

Chip Pearson

What is the Formula to find the Media of a number of cells?

Not surprisingly, use the MEDIAN function.

=MEDIAN(B5:B15)

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

"formula to find the media between cells" <formula to find the
media between wrote in message
...
if i wanted to find the median between the cells B4:B15, what
would i type
for the formula?

All times are GMT +1. The time now is 10:18 AM.