Hey guys, welcome back. So in this video, we're going to speak about another structure that you can use as an alternative to if then else if, which is using nested ifs. However, it's not recommended that you use nested ifs, as their execution time is higher, or the code takes more to get executed. But I'll just show it to you just for you to know it. And in case you see on somebody else's code, you'd understand what they're trying to do. So basically, I've got some code here written using the nested if structure and it's actually doing the same thing as what we were doing on the if then else if sir, testing the value on cell B 18, this cell here in green, and we're checking the value and if the value is one, we'll get a message box one, and if it's two, we're going to message box two.
If it's three, we're gonna message box three, and if it's for a good message box, so for As you can see here, this is the structure of the nested ifs. The nested ifs are basically an if condition. And then on the else you put another if inside it, okay, so it's an if then else, but in the else, you don't put an action to be executed, you actually nest another if inside the else. Okay? And so this if can also be accompanied by an else. Okay?
And then you can nest an IF inside the else for the second if so this way, you're creating nested ifs. And then there's another if here and nested inside the else for that third if, and so because now we've got like four ifs 1234, we would have to put four and if so this is why it's not recommended. First of all, it's complicated to write and the second thing is that The code will be executed in a longer time. So if you test this code, for example, let's say I'm going to put the value here to be four, for example. So let's see how many steps it takes for us to reach the message box that says four. So I'm gonna run through the code step by step here, so 1-234-567-8910 1112 Okay, so we've taken like 12 steps to reach that message box and actually end all the end ifs.
But if we try to execute this code here with if then else if it's 1234566, step seven, with the end if Okay, so, seven steps instead of 12. So, this is why the if then else if structure is more efficient, it executes the code in less time, okay. So so in case that you can do something with the if then else if and you can do the same thing with nested ifs, it is recommended that you use the if then else if structure. And you can see here as well, because it's complicated to read the nested if structure, you can see them indenting my code here, so as to make it easier to read. So as you can see here, uh, putting the if and then indenting the result and then the ELLs and then in denting the if inside the else to give an indication that the if is nested inside the else.
And I'm doing indentations so as to make it easier to read. But it's already a bit complicated to write. And it's not efficient in code execution in terms of execution time as well. I mean, because this is a small macro, probably you won't feel the difference, but if you're doing something complicated using VBA there will be a difference in the execution time. Okay. So this is why this structure nested if structure is not recommended, it is required Did they stick to if then else if structure?
Okay, so that's it guys for the nested if structure, just wanted you to be acquainted with it so as if you see it in somebody else's code you'd understand it. Okay, although it's not recommended to be used. So thank you guys for watching this video and I'll see you on the next one.