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

[formula to find the media between cells]

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

[David Billigmeier]

=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]

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 [email protected]> wrote in message
news:[email protected]...
> if i wanted to find the median between the cells B4:B15, what
> would i type
> for the formula?