You might be thinking, wait a minute, I can actually calculate this by multiplying the grade column by 7, and then add all the notes. What should you score in the final to pass the class? This is the type of question Goal Seek can find an answer to. Let’s say your grade average is 68 before the final exam, and it’s just 2 points shy of a 70 passing grade. After a number of iterations, you will get the result. This is called an ‘iterative calculation’. Excel is going to run different values against your formula until it reaches the target. Essentially, any scenario where you have a formula and a target value can be solved with Goal Seek. Goal Seek is one of those tools that can stop you from scratching your head and give you the answers to problems like what interest rate can you afford for your loans, or how much should you sell a product for to make a profit.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |