Okay, now we're going to test two conditions if their customer service is greater than 95, and the performance is greater than 95. For those folks that have that, we're going to award them with $1,000 bonus and insert a row and just type bonus. Okay, so since I'm testing two conditions, I'm going to want to use the add function. And the add function is going to represent whether all conditions are true. So C to greater than or equal to 95. So D to greater than or equal 95.

Now, as you can see the add function just going to keep going with different tests here that all have to be true in order for the add function to represent true. If you're concerned with just one of the conditions to be true, then you would use the or function instead that check whether any of the arguments are true. Okay, so we've got Alex and William are the only two that have a bonus. Now what if you wanted to replace the trues with $1,000 then what we can do is we can copy this right here, I'm just going to copy that to the clipboard, Ctrl C, backspace it out and delete this and start over. So basically what's going to happen is I'll go back to logical if, and my test will be what we just did there. And you can see that's true, then it's back to what happens if it's true 1000.

And then no bonus, right there. Now notice that no bonus is going to have quotations around it where the thousand is a numerical value. So there's no need for any quotations around the value of Drew. That way. We can do calculations on it later and so forth. ere we go, boom, okay, so anybody who's close we see Omar Garcia is very close.

I'm going to change that 93 to a 95. And just like that, we'll see it right there.