![]() ![]() So, only use Goal Seek for very simple spreadsheets. To solve this, you need to change the data in the cell you want to change from written format to a formula.Įxcel will automatically turn this formula into the answer, but Goal Seek requires the formula for it to function.Īnother issue with Goal Seek is irregularities or simplified results.Ī lot of people who use Goal Seek complain that their answers were rounded up or not accurate – this is because Goal Seek cannot take into account too many variables or formulas. This means that for Goal Seek to work, you need to be using formulas in your spreadsheet. If the error ‘Cell must contain a formula’ comes up when trying to calculate your solution, this means that there is no formula written in the cell you want to change. ![]() Let’s take a look at a few of them to see how you can fix them. Unfortunately, there can be errors and issues that crop up when trying to use the Goal Seek function in Microsoft Excel.
0 Comments
Leave a Reply. |