# Using Goal Seek

#### Elizamag

##### New Member
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>

### Excel Facts

How to change case of text in Excel?
Use =UPPER() for upper case, =LOWER() for lower case, and =PROPER() for proper case. PROPER won't capitalize second c in Mccartney
Assuming data is in the range B2:D6
in Goal Seek:
Set Cell D6
To Value 90
By Changing C5

did not get it..

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?

Did not get the right answer

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

Another way:

Code:
``````      -------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

Replies
0
Views
1K
Replies
1
Views
308
Replies
10
Views
350
Replies
14
Views
1K
Replies
2
Views
596

1,203,506
Messages
6,055,807
Members
444,826
Latest member
aggerdanny

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back