00:00so now let's see how we can actually go ahead and utilize something called solver in excel so to do
00:12that i'm going to go ahead and say item one let's say for example right here let me just go ahead
00:17and click and drag these out right here so that's item two uh two and three as well so let's say
00:23item one is around uh 350 item two is around 800 and item three is around let's say for example 1500
00:33but here just like this but let's say uh i want a total amount right here to be 4 000 right here so
00:41i want the sum to be 4 000 but if i were to go ahead and type in sum and then add up all of these
00:48then you don't get 4 000 right here let me just go ahead and add in an outer uh thickness right here
00:55add in boulder right here just like this make it bold as well so this is going to be the total
01:00so if i want to change the values right here uh in a certain way so that the total becomes 4 000
01:07then i can go ahead and utilize something called the solver so to do that you can go around over
01:13here onto file and then you can go to option right here and then what you need to do is you need to
01:19go around over here onto add-ins right here on the bottom go to the add-ins then go around over here
01:26onto the add-in go and press go and then you get the solver add-in you need to make sure that this is
01:31turned on and you need to press ok so once you go ahead and do that you need to go to the data tab
01:37and then you see the solver right here simply click on it and now you can see it says set objective
01:44right here just like this so i'm going to go ahead right here and now i want the objective
01:49uh b4 so let's just go around over here take the objective right here which is b4 so you can see that
01:56i'm going to set the objective to the value of exactly let's say for example 4 000 right here and
02:03now i want to change the values of this of these three cells right here to go ahead and change the
02:08value for 4 000 right here so if i were to go around over here and select all these three right here
02:13press enter then this is what you have so if i were to go ahead and now click on solve right here
02:19it actually calculates it out and increases out the value or decreases it out accordingly right here
02:25and then make sure that you get a 4 000 uh right here so press ok and you can see that this is what
02:33you have you can you can see that it rounded it up right here to 4 000 so this is 404 1086 right here
02:41and then 25 uh let's say for example right here's uh 2508 and you can see that this is what you have
02:49so you can simply go ahead and make a few changes right here so you can see that the solver is not
02:54actually perfect but this is what you can do so you can go ahead and add and make it 8 right here
03:00and this is what you have so that you can figure out the exact values that you can keep
03:04by maintaining the ratio of the of the items that you already have right there so that is how you can
03:11go ahead and solve problems like these using the solver inside of microsoft excel so i hope you found
03:18this video useful be sure to hit the like button don't forget to share this out with your friends
03:24and family and for more contents like these do follow simple tutorials
