 So this week we are actually going into a little bit more of the advanced functions of Microsoft Excel One of the things we have to think about with these functions is every single one of them is expecting a parameter now let's take for example the EVG educational video game company one of the things that we want to see is Is this the person's birth month now if we cheat and we scroll all the way Over here You can see that we've actually got birthdays this month We're actually just cheating and saying oh if their birthdays in September. So We got to remember that ad one So we do that by looking at the birth year, but first things first birthday month One of the things you notice is as I finish typing out that Excel luckily sort of understands that I'm gonna be going through a The same kind of formatting process. So it just went ahead and applied it to there So now we have to go in and we have to put in that kind of question is this month or Were they born this month? So, you know, we're going to buy a machine cake or something like that. We can see for example, you know low for example Yeah, we would Say yes for her, but forbs on the other hand, we would not because again low birthday month nine Forbes 12 So how do we do that? Well, we're revisiting the idea of what is known as the if statement the if statement If you click on the enter a function, it'll be the first thing that hopefully pops up if not Going down and selecting Logical will sort of reduce everything down to sort of the logical formulas case in point if Now again How an if statement works is it breaks down into three sections the logical test the value if it's true In the value if it's false. So our logical test. We're saying Does their birthday? Begin with a nine basically one of the ways we can do that is through a new function called month Now as soon as I put in month At birth date What I'm saying is all of a sudden pull out the date of Whatever's being typed pull out the month that's being kind of addressed in that that time that daytime and then let's see if it equals dollar sign 80 dollar sign One if that's true if this is true if they are born in September Present a yes However, if they are not what I'm gonna do is I'm actually gonna cheat and I'm gonna go ahead and just put in two quotes here That way again, I don't see anything and as soon as I hit okay You see all of a sudden, you know low birthday sped Spadaluda him Johnson Johnson these are all of those names are now being established