Hey guys welcome back. So in this video we're going to discuss the end and the or logical operators in Excel VBA. So the end and the or logical operators in Excel VBA work exactly the same as the end and the or functions in Excel and then only Excel grid. So as we know, the end function will take some logical tests. And if all the logical tests are true, then it will use the true and if any of the logical tests is false, then it will yield a false. That's what the added function does.

And that's what the end logical operator in Excel VBA does. And the order function in Excel takes some logical tests. And if any of the logical tests is true, then he will yield the true and actually If all of them are false, and this is the only case it would yield the false, then it's going to yield a false. So I've created a simple macro here called and, or, and as you can see, I'm applying logical tests on Selby 21 that is colored in orange here. And as you can see here, the first test here the first if condition says if the value of cell B 21 is greater than or equal to one, and its value is less than or equal to five. So this is a condition and this is a condition and there is an and logical operator here.

So basically, in order for this whole if condition to yield a true, this needs to be true, and this part as well needs to be true, and they will actually be true in our case here because Selby 21 has A value of three, which is greater than or equal to one, and at the same time, it's less than or equal to five. So that means that if we execute this macro here by pressing f8 on our keyboard, this if will yield the true and we're going to see this message box that says between one and five, you can also add more than two logical tests for the add here. So we can actually add to be 21 value does not equal to two for example. So if range b 21 to a value is greater than or equal to one, and it's less than or equal to five, and at the same time as well as not equal to two.

So all these logical tests are going to yield a true so that means that the whole if will be a true and we're going to get this message box. However, if any of these logical test is false, then the whole if will be false. Okay, because in case of the end, all the logical tests need to be true in order for the logical test to be true. So for example, if we change this to be greater than or equal to 10, for example, so when this logical test is done, this is going to yield a false so the whole if will be false. So let's try that here. As you can see, here, it's going to bypass it because she'll do the false and this one will also will use the false for the or one and we will speak about that shortly.

But as you can see here, for the end, all the logical tests needs to be true in order to yield a true and if any of them yields a false then all the logical tests will be false. Now we're going to speak about the or logical operator. So here we've got the second line of code here has an or logical operators that says elsif range between one to a value is equal to 10 or is equal to 20. If we make this a 10, then the fact that this will be true will make the whole elsif true as well. Okay? So, in case of the or if any of the conditions you're testing is true, then the whole logical test will be true.

Okay, so if we run this macro, because here, we're going to actually execute the messagebox for that one, because the else if will be true, and that is because one of them is true. Now, the only case that this elsif in this form will be false is that if both are actually full, so if we change the value here to 11, and we run the macro, it will actually yield a false and the message box 10 or 20 will not be executed because the value is neither equal to 10 nor equal to 20. As you can see here, You can also mix between the order and the end. In that case actually, it is preferable that you would put brackets for both readability and also for Excel to be able to understand what you want to do. So, for example, if I write range b 21 dot value is equal to 10 or B 21 dot value is equal to 20 and b 21 is less than 30.

And we change this actually to 10. So, in that case, actually, this will yield a true this whole thing will use to true and this whole thing also will lead to true because the value is equal to 10 or equal to 22. This part will yield the true and the value is also less than 30. And in that case, actually this whole bunch which is To logical tests with an or logical is treated as as one logical test and this is treated as another logical test, and they are both being tested with an end logical operator. So in this case, it will actually yield as true and we'll have this message box 10 or 20 pop up. So let's run the macro here step by step.

You can see here, I've got the message box 10 or 20. popped up. So if you're going to mix between the end and the or it is preferable and highly advisable, it's a good practice to put your tests between brackets for both readability and also to be able to convey the message or what you need to do to excel vba correctly, so to be able to convey your message correctly. Okay. So I hope that was informative for you guys. I hope you understood the difference between the end and the or logical operators. We're going to use them quite a lot on the course.

Okay, so thank you very much for watching this video and I'll see you on the next one.