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

preview_player
Показать описание
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.
Рекомендации по теме
Комментарии
Автор

God bless this man for helping my pass my business computer applications class

TitleFightEnjoyer
Автор

Mr spreadsheet just saved my brain from bursting out 😂😂, I have been on this goal Seek calculations like forever 😢. Thanks

serahchizormam
Автор

AMEN GOD BLESS THIS MAN FOR REAL IT SAVED ME SO MUCH THANK YOU I SUBSCRIBED

nosibor
Автор

I have a mac. I tried using goal seek but it says it can't find a solution. Is there any way to fix this?
Thank you

ivonnelopez