 So now that you've played with the ands and the or functions one of the things that we can also do And if you're really feeling froggy is we can actually place an if Function inside of an if function what craziness, right? How we do this is basically the same operation as Before we would do the exact same kind of concept now for our Textbook we're looking at the bonus amount. We're saying Based on their preferential rating How much of a bonus should they get well if you want to cheat you can come over here? Into the x column and you can see if you get a rating of one You get no bonus if you get a rating of a two. Hey, you get the 2,500 rating by the three Ah ha ha and you get excellent service So again, we go through the same song and dance we start off with my if statement Now again, the first thing I need to look at is my Perf rating and we want to see does it equal one? Now the first thing you're noticing is I'm seeing a lot of falses going on here And it's true. It's because a lot of people are not going to be a rating of a one Let's just kind of see that in action. You see I've got one right here. So I've only got one Now if it's true if they get a rating of a one I give them a zero bonus now How do I reference that? I don't just type in zero. I come over here I'll put it in now. I am going to absolute value that But now we get into the more complex portion We get into here because obviously as you can see we have a two and a three So suddenly I have to go. Oh well Does the preferential rating performance rating? Sorry does it equal two or three? So again, if we think about an if statement and if statement has a logic test What happens if it's true what happens if it's false? So I come in here and I put in another if statement Now inside of here. I'm doing the exact same thing. I was doing a second ago I want to check the performance rating and see if it is equal to two if it is You notice I see some Falses there if it is equal to true then I want to give them the rating The bonus of twenty five hundred if that is false we're using the process of elimination here and Making the assumption that you can only be one of three potential ratings So all of a sudden as you can see that three that I had here It's going to be 75 as soon as I hit okay every single one of my Employees now has their specific bonus rating by using this nested if structure