WPS office software could be compatible with Microsoft Office, and these training contents help students or home workers finish their work efficiently. When the results satisfy the maximum change within the maximum iterations, the calculation will stop. Check Iteration, and set the Maximum iterations and Maximum change (accuracy) as needed. Select the cell A9 in Set cell area, enter “ 900 ” in To value area, and select the cell B6 in By changing cell area.įor some complex equation, some iterative computations are needed and it ’ s impossible to calculate the exact value, but Goal Seek can work out a value that satisfies a certain margin of error. The following from Microsoft only discussed it in MacOS & Windows: Use Goal Seek to find the result you want by adjusting an input value - Office Support. Microsoft controls the features offered in Excel for iOS.
Click Data > the What-if Analysis drop-down button > Goal Seek. Since Excel is a Microsoft project, you should let them know of your desire. Tips: Goal Seek only works when there is a formula.īased on the sales of Lipstick, Liquid Foundation, Eye Cream and Body Lotion, the Commission now is 671.65.Īt this point, w e want to know that when the commission is 900, how much the sales volume of face cream should be. To make it more comprehensible, we take a simple case as an example.Ĭommission equals to 5% of total sales (A9=SUM(B2:B6)*0.05). Assuming a certain result of a formula, work out what one of its variables should be. Goal Seek feature is used to solve an equation.
