Remember Me?

#1
November 1st 04, 02:06 PM
 spooker4u Posts: n/a

Am trying to create a function within my worksheet to give student's
their grade at any given point in time within the classes
term/semester. (i.e. if 7 week class, I can tell them what their grade
will be on week 4).

Currently I am using a point system (i.e. 9/10 = 90%) then averaging
each assignments averages together to determine the student's total
can't figure out is how to look at my workbook/worksheet and tell the
student what there grade IS today (since the values for future
assignments are 0 or null).

I suppose that I could change my average function on each of my
student's rows to reflect the average of only what is being requested,
but that is very time consuming, and not very practicle... I was hoping
to use "date()" function to have the cell determine based on the date
what their grade would be today if I/they were done with the class.

Any ideas?

--
spooker4u
------------------------------------------------------------------------
spooker4u's Profile: http://www.excelforum.com/member.php...o&userid=15935

#2
November 1st 04, 02:49 PM
 Bernie Deitrick Posts: n/a

Spooker,

The easiest way is to use the AVARAGE function, but leave all ungraded calls
blank (don't enter a zero unless that is the actuall score). Excel will
ignore the blanks, and give you the average for only the entered values.

HTH,
Bernie
MS Excel MVP

"spooker4u" wrote in message
...

Am trying to create a function within my worksheet to give student's
their grade at any given point in time within the classes
term/semester. (i.e. if 7 week class, I can tell them what their grade
will be on week 4).

Currently I am using a point system (i.e. 9/10 = 90%) then averaging
each assignments averages together to determine the student's total
can't figure out is how to look at my workbook/worksheet and tell the
student what there grade IS today (since the values for future
assignments are 0 or null).

I suppose that I could change my average function on each of my
student's rows to reflect the average of only what is being requested,
but that is very time consuming, and not very practicle... I was hoping
to use "date()" function to have the cell determine based on the date
what their grade would be today if I/they were done with the class.

Any ideas?

--
spooker4u
------------------------------------------------------------------------
spooker4u's Profile:

http://www.excelforum.com/member.php...o&userid=15935

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post Renny Bosch Excel Discussion (Misc queries) 6 December 31st 04 02:07 AM PE Excel Discussion (Misc queries) 2 December 7th 04 01:00 AM Drew H Excel Worksheet Functions 3 October 31st 04 06:55 PM Ron Excel Worksheet Functions 1 October 29th 04 06:29 AM Saariko Excel Worksheet Functions 9 October 28th 04 11:52 AM

All times are GMT +1. The time now is 04:59 PM.