Using Goal Seek

[Elizamag]

How can I use theGoal Seek command to determine the minimum number of points a student needs toearn on the final exam in order to make a grade of “A” in the class. (90-100 points = A.)

Grade Report
		Assignemt	%	Points Earned	Total Points
		Applications	25%	92	23
		Written Tests	25%	85	21
		Production Tests	30%	90	27
		Final Exam	20%		0
		Total	100%		71

<colgroup><col width="64" style="width: 48pt;" span="2"> <col width="105" style="width: 79pt; mso-width-source: userset; mso-width-alt: 3840;"> <col width="64" style="width: 48pt;" span="3"> <tbody>
</tbody>

 

[BadgerRoad]

Assuming data is in the range B2:D6
in Goal Seek:
Set Cell D6
To Value 90
By Changing C5

 

[Elizamag]

did not get it..

 

[BadgerRoad]

When you say "did not get it" do you mean you don't understand the way I suggested using Goal Seek or you didn't get the right answer?

 

[Elizamag]

Did not get the right answer

 

[BadgerRoad]

Assuming B2:B5 contains the percentages (B2=25%, B3=25%, B4=30%, B5=20% and B6 contains 100%)
Assuming C2:C5 contains the points earned (C2=92, C3=85, C4=90 and C5 contains the value you are trying to solve for)
D2:D5 contains Total Points respectively and D6=Sum(D2:D5)

In Goal Seek:
for Set Cell: specify cell D6
for To Value: enter 90
for Changing: specify C5
You should get a value of 93.75 in cell C5 which will produce a value of 19 in cell D5.
The total points earned in cell D6 will be 90

 

[shg]

Another way:

      -------A-------- --B--- --C-- --D--
  1      Assignment    Weight Score  Net 
  2   Applications        25% 92.00 23.00
  3   Written Tests       25% 85.00 21.25
  4   Production Tests    30% 90.00 27.00
  5   Final Exam          20% 93.75 18.75
  6   Total                         90.00

In C5: =(90 - SUM(D2:D4)) / B5