Hey guys, welcome back. So in this video we're going to discuss the simple if statement. So the simple if statement is used in checking if a condition has been achieved or if a condition is true. And if that's the case, then there's some code or some actions that you're going to take based on the fact that this condition is true. And if the condition is false, then the actions will not be executed or the code will not be executed. And its structure in its simplest form is basically if condition equals to true, then there is some code to be executed here.

And then we've got the end If so, you will basically have some code wrapped between the if and the end if and this code is executed. If and only if condition is equal to true And of course, if the condition is equal to false, then the code is not going to be executed. So basically, the code execution will resume after the end if statement and the code part here will be bypassed, he will not be executed. Okay, so let's have an example here. So the example I've got here is basically to test that some sales persons are achieving the target. And if that's the case, we'd have a message box popped that this salesperson has achieved the target, and if not, we will not have the message box pop.

So basically, I've created here, two variables. The first variable is the sales target, which is an integer, which is going to be basically our target which is 20,000. And we've got the salesperson which is going to be actually taking the name of the salesperson as a string from this cells containing this salesperson and this macro needs to be executed while you're actually having the sales amount selected. And if you check the variable salesperson where it gets its value from, it's basically the value of the active cell dot offset. So that means we're going to move from the active cell zero and negative one zero rows negative one, that means one column to the left dot value. So while you're setting on the sales amount, the salesperson variable gets its value from the cell that is zero rows and negative one columns that means one column to the left and that means the column containing the salesperson and then this is our if statement here, if the value of the active cell dot value which are standing on which contains the sales amount is greater than or equal to the sales target, then this message box is going to be pumped which is the salesperson whoever he is Name is achieved the target and notice here that we've got a space before the word achieved here, so as to have a space between the name of the salesperson and the word achieved.

Okay, so let's start going through this code here, you need to make sure that the value for the sales amount is selected at the beginning. And then we're going to go through the code step by step. So here the variable called sales target, is given the value of 20,000, which is our target. And then here, we'll get the value of the salesperson in this case is Jennifer because we've selected the sales amount for Jennifer and then if the value of the active cell is greater than or equal to the sales target, is it yes it is. So this message box is going to be popped. So we're going to go to execute the message box is going to say Jennifer achieved the target and if and sub and DD two to highlight the value for the sales amount for each sale.

Salesperson to be able to execute the macro. And this one as well as achieved because he's 21,000. And then if we go to jack, he's 15,000, he's less than two target, so he's not gonna have the message box. And that's it. And you can do it for each salesperson. But you need to make sure that you've selected the sales amount.

In the future when we learn about loops, you're going to learn actually how to do this without needing to have the cell for the sales amount selected, and you can just loop through the cells and get that done without even needing to select the cell for the sales amount. Okay, so this is not actually the best way to do it. But it's just an example to demonstrate the if statement. I want to note something else here, which is that you're actually able to write the if statement and A line of code that you need to execute on one line and remove the end. If you're able to actually do that, I'm going to cut the message box here, put it on the same line. So if and then the condition is tested, then do this and remove the end if your code will work this way.

However, this actually has two downsides. The first one is that you can only execute one line of code this way as a result of the condition that you're testing being true. So you cannot put multiple lines of code to be executed. That's the first disadvantage. The second one is that the code does not look very neat. It is actually better to have the if condition put on one line, and then put it then and then put the lines of code that you need to execute and put an end if This marks the beginning and an end for you.

If statement makes it more readable. So actually, if we test this code this way, if we step through it step by step by using f8 on our keyboard, you can see here that the code executes fine. And with no problems. However, this is not the recommended way to write an if statement, you'll find more than 90% of the people write the if on one line, and then the resulting lines of code that need to execute and put an end if This marks the beginning and an end for the if statement makes your code a lot more readable. So I hope this lecture was informative for you guys. We will learn more about the if statement in the upcoming videos.

Thank you very much for watching this video and I'll see you on the next one.