Use Goal Seek to generates best input for target results

Goal Seek is another amazing “What-if” analysis tool in Excel, with cool features that are very useful in generating the best input for a formula you already know the result, but not sure of the exact input. The limitation here is that it only work with one variable input. Solver is an ideal tool in[…]

Shares 0