 So let's say for example that I get a bonus whenever I make a sale Well, let's say I get 3% whatever sales I make I get that as sort of just a little bonus to my amount So what I want to do is I suddenly want to see well my goal Is to get 25,000 dollars total so how do I can how do I do that? Well right now I don't know my sales and one thing I could do is I could come in here And I could type this stuff out and I could Get my guess and check up, but look at that You know all I'm doing is I'm just arbitrarily picking numbers and throwing them in there So instead what I'm able to do is I'm actually able to use something known as a goal seek That's inside my data tab. You see goal seek basically does that entire concept for you I don't want to spend the time going through and trying every possible number to eventually figure out What it is you can see it I'm gonna be doing this For a while, you know, so instead what I'm able to do is I'm able to use goal seek So over here. We have the same called what if analysis It's exactly what kind of what it it says what if and I click on it and I get suddenly this option to do a goal seek So all of a sudden you see I can set these values So what am I gonna do the first thing I want to do is I want to do my set value now It already says be one, but this is actually incorrect. This is what I'm gonna be changing So that's actually gonna be coming down here My set value is actually bonus amount and I can click on it. It'll change it You can see it gives it some dollar signs and that just means it's an absolute reference to what value Well, that's where I got this 25,000 and I can set it here if I'd like or I can type it out and Then by changing what sell what sell do I have to change to a hopefully eventually get 2,500 here in my case be one now. What happens when I hit, okay? What's going through all the possible combinations? You saw it jump a few times and now officially I basically have to make sales of $83,000 300 or 83,333 dollars and 33 cents with my bonus of 3% to get all of a sudden this 2,500 now I can hit cancel and what if we change it up? Maybe I get not so much Maybe I only get a 1% bonus. Well, I can do the same thing. I can run that what if analysis set this to 2,500 by changing this number Well, all right, let's see how much my sales how many sales I'm gonna have to make to get this bonus You see it's jumping a bunch now all of a sudden you see this nice little hash What this is kind of indicating is it's such a big number? I have to adjust it So what about I do I can double-click or I can click hold and drag You can see if I sell 2,500 $1,000 worth of kind of goods materials from whatever I'm doing and I get a bonus of 1% There I am. So this is sort of my commission