How to use the Goal Seek function in Excel

[@Never124.]

I can't understand anything. 😟😟

[@HoodixTells]

MY MILKSHAKE BRINGS ALL THE ALDO MENCARAGLIA TO THE YARD

[@Singh_Garry]

We could simply do like 150000(Target)-90000(Actual Sales)=60000(Predicted contribution for Product C) Now to calculate the Revenue of Product C we could simple divide 60000/15=4000*100=40000 Unable to understand why Goal seek was used for such a simple calculation.

[@Bozott]

because the goal was to display and teach goal seek. Yes it would have been more efficient to work backwards instead of the trial&error goal seek, but the actual problem here isn't important because its just trying to demonstrate how to use goal seek, which it uses well. A better problem would have been one that is hard to reverse, for example finding a specific point of interest on a function that is difficult to differentiate. Setting up a problem like this doesn't add anything to the video, but requires a lot more work.

[@Alex-di8ti]

This is Matrix level Excel, thank you!!!

[@arshadinaumaranajib3840]

"Cell must contain a formula"....sory it didnt work for me

[@EntUni8563]

How do we understand this you didn’t show the function of the cell my is not working

[@hifitech01]

hello can you help we with my spreadsheet I am struggling to do this and add few other functions. If you can help that would be great??

[@Tamerlane619]

Beautifully explained!!!!

[@PakistaniGOOGLE]

i understand that you use the option but why? how the division works?

[@pabl1to33]

Question: I am trying to find the IRR by setting the NPV to zero. How can I use Goal Seek without getting my NPV value (which I still need in the sheet) to zero. If I use Goal Seek my NPV value goes to zero, I have my IRR, but I still need to use the original NPV value which is now gone...

[@jakefarrugia5000]

There’s a Npv and Irr function.

[@lekhshisodiya6094]

so simple and easy and fun to learn example margins and stuffs sir i insist you to find more harder to get more thumbs down

[@DeansVideoClips]

Nice CLEAN and well presented video. Thank you. Regards Dean.

[@georgefrederickernestalber6572]

very nice

[@classyal8035]

We all can never thank you enough, God bless ❤️

[@kaboomwinn4026]

the way I solving is work backward by 150,000-90,000=60,000 then 60,000/0.15=400,000. to check my work just place it in the B7 if it checks out with the target number.

[@MalcolmBlk]

What if I don't know the goal in value but know I want to get max value? And what if I have more than 1 number that can vary?

[@Nikunj573]

Thank you!

[@david1387]

wish there was a harder example..all i could think of was how easy to was to solve in my head in 5 seconds vs using goal seek

[@richardwilliamjohnson8566]

Well, we aren't all super high IQ geniuses from China, Mr Wang :)

[@carla4954]

@@richardwilliamjohnson8566 ahahhahahahaha

[@atulsinghaarav5178]

7210074737 whatsapp

[@rpeak99]

Lol if you just went 150-90 it’s a solve for x problem.....I googled to see wtf this tool is....if it’s not robust for complicated problems this is probably a wasted tool - those that would know to use it can fio wo it.

[@MOHSINALI-bk2qo]

Thank you so much Thanks you Thanks you

[@SagarPatil-zk9cj]

Thanks man

[@tuskun3072]

GOOD VIDEO THANK YOU SO MUCH I LOVE YOU

[@giango3500]

thank you for a very useful guideline!

[@michaelhitchcock4265]

My excel does not have a what if

[@tharkirythmicdanceclass7114]

Thanks you

[@suchitkumarbharati2775]

i like this

[@slytewrx7408]

1:38

[@azscott8737]

who would thumb down such as a useful video!

[@extinct4227]

your voice is really relaxing , thanks for the video

[@jakubpecko275]

wooow 🤯mas stastie

[@lamotivationcheick2268]

Thank you so much sir it's wonderful

[@Obezuanka]

Thank you so much!

[@RISHIDEVANVR]

useful thanks man

[@liuerlin2256]

Thank you!

[@TheWld113]

Awsome !!! thanks

[@GauravSingh-ij1lo]

Very Illustratively explained , thanks

[@amrinsweety7670]

Thankq sir

[@Yourlocalhitman_x]

thanks bro

[@trongtaole1378]

Thank you so much !

[@govardhanbijithkumar3912]

what the shit

[@devanshbanjade3765]

Very. Bad

[@iamnowherecauseofyou]

thank you

[@hihellogaming4407]

Thnx

[@kaustuvkar6311]

Thankyou Sir it really helped me

[@talashakouhi7737]

❤❤❤❤❤

[@jonahvimeo4276]

very simple, illustrative, very good !

[@datastako156]

thank you for sharing!

[@silkyshruti9460]

Thank you so much 💓

[@amanda.s_life]

FOR ME IT IS COMING #NUM!

[@popcorn_224]

Big thumbs up. Thank you!

[@denychangy7386]

Thank you !!

[@mansourzanaty691]

Thank you very much, very helpful.

[@adnanbhatkashmir]

Thank you :)

[@ravingagunawardana178]

Thank you!

[@lubalethudube186]

Thank you!

[@aidos4381]

Awesome

[@premaratnebalasooriya7914]

Tyank You

[@aashagulshan6197]

Thankyou!!!!

[@fufularue3627]

THANK YOU!

[@sianateelucksingh604]

Thank you!!!

[@muhammadaaiyz6796]

Simple and easy explanation👍

[@Scorbunny890]

Very good

[@look-kaew3999]

useful

[@hahaha4568]

super useful

[@sksajidhussain1848]

Nice and simple explanation

[@mengo_]

Thanks

[@paulreece9606]

yo wan summmmm??

[@ДмитрийБулан-щ8в]

Vika privet!

[@paulreece9606]

word up!

[@paddydee2722]

makes no sense! there was no information about setting out the calculations that the goal set requires to enter the calculation into the goal seek. the video has no purpose !!! you should of started with an easier calculation, that was easier to enter to emphasis the GOAL SEEK FUNCTION! the principle of YOUR VIDEO!!!!!!!!!!!

[@shibanisonar6315]

U make so easy to understand.. thank you sir

[@deivanarley7411]

Thanks man, very helpful.

[@markferry2195]

is there any way to set the "set value" field to a cell, rather than a firm value?

[@paddydee2722]

in the calculations you had to multiply column B by column C, into column D. then sum them at the bottom on the total rows( either by using the auto sum, or entering the equals sign "=SUM(the three rows) the the enter key. then the goal seek would have worked . hope that helped

[@siqili9563]

Waste of time. No explanation of formula

[@anirbanbasu3981]

kaka chole na