How to Use Excel’s Goal Seek and Solver to Solve for Unknown Variables

excel-goal-seek-solver

Excel is very capable when you have all of the data you need for your calculations. But wouldn’t it be nice if it could solve for unknown variables? With Goal Seek and the Solver add-in, it can. And we’ll show you how. Read on for a full guide on how to solve for a single cell with Goal Seek or a more complicated equation with Solver. How to Use Goal Seek in Excel Goal Seek is already built into Excel. It’s under the Data tab, in the What-If Analysis menu: For this example, we’ll be using a very simple set...

Read the full article: How to Use Excel’s Goal Seek and Solver to Solve for Unknown Variables



from MakeUseOf http://ift.tt/2AGQkkh
via IFTTT
Share on Google Plus

About Oyetoke Toby

    Blogger Comment
    Facebook Comment

0 comments:

Post a Comment