Another one of my favorite Excel tools is Goal Seek. You can use Goal Seek if you know the result that you want from a formula, but are unsure what input value is needed to get the desired result.
In this tutorial we will show you how to use Goal Seek to calculate the sales price that gives a desired gross profit on a known cost of goods.
Ещё видео!