ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Calculating using the Median function?? (https://www.excelbanter.com/excel-discussion-misc-queries/226230-calculating-using-median-function.html)

Jrf

Calculating using the Median function??
 
I need to use the Median function to calculate exam scores that are in cells
B17 through B52. How do I go about doing that?
I am trying to get the Median or the middle score for the first exam listing
within the above cells..

Please help???

Max

Calculating using the Median function??
 
=MEDIAN(B17:B52) ?
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:25,000 Files:370 Subscribers:68
xdemechanik
---
"Jrf" wrote:
I need to use the Median function to calculate exam scores that are in cells
B17 through B52. How do I go about doing that?
I am trying to get the Median or the middle score for the first exam listing
within the above cells..

Please help???


Jrf

Calculating using the Median function??
 
Thanks Max! I was getting confused because I was choosing Median under More
Functions, statictials and it was asking for number 1 , number 2...Crazy but
true I was confused... Guess it's too late to be working with numbers!
Thanks again!

"Max" wrote:

=MEDIAN(B17:B52) ?
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:25,000 Files:370 Subscribers:68
xdemechanik
---
"Jrf" wrote:
I need to use the Median function to calculate exam scores that are in cells
B17 through B52. How do I go about doing that?
I am trying to get the Median or the middle score for the first exam listing
within the above cells..

Please help???


Max

Calculating using the Median function??
 
Welcome, glad you got it going.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:25,000 Files:370 Subscribers:68
xdemechanik
---
"Jrf" wrote in message
...
Thanks Max! I was getting confused because I was choosing Median under
More
Functions, statisticals and it was asking for number 1 , number 2...Crazy
but
true I was confused... Guess it's too late to be working with numbers!
Thanks again!





All times are GMT +1. The time now is 02:26 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com