Free Excel VBA Course #15 - IF Then Else Statement in Excel VBA

Рет қаралды 16,254

4 жыл бұрын

In this video, I will show you the IF statement in Excel VBA. You can use the IF Then Else statement to check for conditions and perform an action based on it.
I take an example of students' scores and show how to use the IF THEN ELSE statement to assign a grade based on the score. I also cover how to use nested IF statements, where you check for a series of conditions and perform an action based on which condition is correct.
IF THEN ELSE can be really helpful in Excel VBA, especially when you use it with loops (something we will cover in the later videos in this VBA course)
✅ Download File: bit.ly/vbacourse-15
☕ If you find my Excel videos useful and would like to support me, you can buy me a coffee - www.buymeacoffee.com/SumitB
Free Excel Course (Basic to Advanced) - trumpexcel.com/learn-excel/
Best Excel Books: trumpexcel.com/best-excel-books/
Subscribe to get awesome Excel Tips every week: kzfaq.info...
#Excel #ExcelTips #ExcelTutorial

Пікірлер: 11

@dustinbowman2644 3 жыл бұрын

Such a good instructor

@sanjayagarwal7243 2 жыл бұрын

Sir your lessons are very simple and easy to understand. Thanks.

@margad-erdeneboldbaatar4704 2 жыл бұрын

Thanks so much.

@abhinaygarg7029 3 жыл бұрын

Thanks

@charants3021 3 жыл бұрын

Why can't we use the range function to apply if statements, going active cell by active cell is not feasible when we have huge dataset?

@sanjayagarwal7243 2 жыл бұрын

Do you also have advance lesson where in I have a huge xl sheet and want to insert some formulas using vba and also to extract data by filter and copy.

@feelzofmusic 3 жыл бұрын

hey.. your videos are very easy to understand. can you tell the shortcut you're using to delete the entire formatting of a cell in this video ?

@gauravludhwani2171 2 жыл бұрын

Range("A1").ClearFormats

@artanis5163 2 жыл бұрын

poor Rachel only girl failing feelsbadman lol the lesson is good though thanks bro

@asmitaghorai7332 2 жыл бұрын

Yeah, the sheer underestimation, devaluation and ostracism women active in the fields incorporating technical sciences [and others likewise] have to endure even in the 21st Century, smh dude that's nothing to be LOL'ed at. I might sound a bit dopey as I say this but in all honesty and sincerity, do you really think it all has ever been fair? Terrible notions, too bad this isn't the first tech support channel I'm discovering that did this. Such filthy baiters! Fvck these gender-stereotypes that normalize alienating women off of these terrifically brilliant forums, which is after all considered way too 'masculine' and 'numberwork-rich' for anyone a non-male to excel in. _Education has no gender._