Bacon is so good by itself that to put it in any other food is an admission of failure. You're basically saying, "I can't make this other food taste good, so I'll throw in bacon."
Goal seek is easy. I will give you a preview here. Open up a blank worksheet and enter the value 1 in cell A1, then enter the value 0 in cell A2. In cell A3 enter the formula: =SUM(A1:A2).
Now, let's assume that you want the value in cell A3 to be equal to 100. Go to the Data Ribbon, then select the What-if Analysis dropdown in the Data Tools section. Select Goal Seek. You will now be presented with a dialog box entitled: Goal Seek. Set the Set cell: to A3, set the To value: to 100, then set the By changing cell: to A2. Now, click on the OK button. Click on the OK button again. You have just done a Goal Seek. In more real world examples, you can have much more complex formulas with the condition that one of your variables must be an available cell reference that is not a formula or label, but just a number.
Reply from Richard Rost:
Thanks, Bruce.
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Excel Forum.
