I have a grade file with this formula in B12.. When I put what percent I want the grade to count in row 9 the formula in B12 uses it to get the raw score even if there is no grade put in as in I12 in the attached file. How can I get it to work for only students that have an actual score on the work?
Please Login or Register to view this content.
Last edited by Wskip49; 12-18-2008 at 03:53 PM.
Looking at your posted workbook....
I believe the problem is in cell AU9
Try this:
Does that help?Please Login or Register to view this content.
Last edited by Ron Coderre; 12-18-2008 at 11:06 AM. Reason: add an alternative formula
That gives me the same raw score for B12 but for all the rest it want work. I think the variable in AU9 has to apply to all students. In the original file I have over 20 students listed.
I think I understand....
IF...The Cumulative Weight Pct can be different for each student (based on
whether they have a score for a particular item), then try this:
Copy those formulas down for each student.Please Login or Register to view this content.
HOWEVER...if the Cumulative Weight Pct is static for ALL students and
each pct is only used when ANY student has a score for that category,
then: I'd put Effective Weight Pct formulas under each Weight Pct to
determine if it's used or not:Then you can use your original formulas, but reference $AU$10, instead of $AU$9.Please Login or Register to view this content.
Does that help?
Those Work Great. Thank you so much.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks