 So last week we spent some time learning about some of the different kind of features in Excel For example that I can come in and I can do things like conditional formatting Or if I happen to have a lot of data I can come in and use the pivot table But now all of a sudden we see not always gonna be sifting through data Maybe instead I'm gonna be working off of calculations and you can see we have actually just a nice little loan that we've been working off of We got Mary Beth Williams. She's got a nice very nice credit score. That's not bad not bad at all And she's gonna be buying this loan out at $21,000 as long as she puts a down payment of $3,000 on it first Now it's gonna be for three years and we'll say that it started about six years ago. Well Just by sheer fact we can actually kind of go through a few of this steps already and that's what we've done This is actually if you can kind of see the PMT if you want to see a magic trick Hold your control key and then that kind of symbol right beside the one control Look at that. That's pretty So all of a sudden you can start to see where these are coming in So the payment that I'm making every month is coming from B 11 divided by 12 So B 11 right there in my interest rate divided by 12 B 6 times 12 B 6 times 12 and negative B 13, which is that loan amount So that's how much money for example. We got now. Okay. I can't see the loan amount. So how do I switch over? Well, I just hit control and that little tilled aposhe fee again so all of a sudden All right Loan amount 18,000 is still kind of waiting. So now all of a sudden I want to kind of just make a little bit of an assessment And for example, I want to basically ask a simple question Well, if I take this amount and I take this amount, you know my B 13 what loan amount I got and the purchase price of that loan Well, did it come out to be a good ratio? Have I spent a lot of it? Or do I need to kind of give a little bit of an extra fee? So what I can do is I can think of this as a fork in the road if for example this ratio of B 13 to B4 B 13 to B4 happens to be Over 80% or greater than 0.8. Then I want to go ahead and put an assessment fee of three hundred dollars on it Otherwise zero dollars. So how do I do that? Well, I'm gonna come over here to this nice little tab called formulas Now inside of formulas, you can see that we have all of these different functions inside of Excel's disposal, you know financial all the different financial options you might want Text all the different things you want with text lookups and references math and trig obviously But we want to focus in on this logical section Because inside that logical section There's this thing known as if if you read through that kind of little statement checks whether a condition is met and returns one value if it happens to be true in our case is 300 or a Value if it's false in this case are zero. So I'm gonna click on if This pulls up a nice little dialogue box and the first thing it asks is What is my logical test now? That's actually what this is right here? I want to take this concept of doing a math equation like this and then doing a comparison That's actually kind of what the greater than symbol is doing is saying whatever this math equation equates out to Let's say is it greater than or less than 0.8 That's actually not asking if it's greater than or less than 0.8 Let's see what it happens. Well, I'm gonna go ahead and just come in here, and I can actually click on 18,000 Look at that pretty you see it already gives me a true now That's because we're working off of the assumption that because there's a value and it's not doing any comparisons The presence of a value means true. Okay, not terribly great But for our sake come in with that division some and I'm gonna go look for my before before purchase price Boom since it's still a value whatever that turned out to be it's not the absence of a value It still comes out to be true Still not what I want. I Want to come in and put in that greater than sign Now what this is going to do is it's not going to tell me whether or not this number is greater than or less than this Number it's going to say whether or not this is a true statement or a false statement So when I come in and say 0.8 what I'm seeing is B13 divided by B4 B13 divided by B4 is Equals out to some number if you want to play the calculator game go ahead Is that number greater than? 0.8 well in this case. Yes, we can see it is true However, if I had said is it greater than 0.0 Greater than one for example. No, it is not true So this allows me to kind of see whether or not these math equations kind of equate out correctly Now it says value if true and we can think of this as sort of a fork in the road If this is a true statement, I want to come over here to 300 If this is a false statement, I want to come over here to zero And that's actually what value of false is kind of indicating You can see Excel actually will give me a nice little sneak preview as well as to what sort of my kind of result will be this time But now all of a sudden what this allows me to do is it allows me to make changes say for example the purchase price turned out to be $18,000 I still get the assessment, but what happens if it was? $15,000 ah see now our assessment changes because 512 divided by 15 doesn't equate out So it allows me to kind of just have a little bit more mathematical control over my spreadsheet