the is Kimmer again, got past the other mess now I cant get past then wanting
to modify formula in sections worksheets based on data obtained from my
grading criteria worksheet.
A9 B9
Exam type Weight
A10 B10
Exam1 25%
Exam2 25%
Final 50%
they want you to change exam 1 to 15% and final to 60%. I did this
manually. Then they want you to get the crieteria from B10:B12. Original
formula in Column E of sections worksheets is =SUM(B2*0.25+C2*0.25+D2*0.50)
I did what my books says to do. go to sections worksheet make sure they are
still grouped. click on cell e2 and type = click on grading criteria
worksheet and highlight the B10:B12 cells and click on the enter button in
the formula bar. I get and error when it switches back to the sections
worksheets. #Value. What am I doing wrong now?--
Too old to be in college