Excel Tip #4: Using Goal Seek to Calculate a Value

Mr Spreadsheets
Mr Spreadsheets
81.4 هزار بار بازدید - 12 سال پیش - Another one of my favorite
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.
12 سال پیش در تاریخ 1391/05/10 منتشر شده است.
81,423 بـار بازدید شده
... بیشتر