Free Excel VBA Course #15 - IF Then Else Statement in Excel VBA скачать в хорошем качестве

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

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) ✅ VBA Course Download files: https://trumpexcel.com/course-downloa... ☕ If you find my Excel videos useful and would like to support me, you can buy me a coffee - https://www.buymeacoffee.com/SumitB Free Excel Course (Basic to Advanced) - https://trumpexcel.com/learn-excel/ Best Excel Books: https://trumpexcel.com/best-excel-books/ Subscribe to get awesome Excel Tips every week: https://www.youtube.com/user/trumpexc... ------------------------------------------------------------------------------------- 0:00 - Introduction 0:46 - Creating a basic VBA IF-Then-Else statement 3:00 - Single-line IF statements in VBA 3:30 - Line continuation in VBA code 4:22 - Using nested IF conditions in VBA 7:45 - Alternative nested IF syntax 9:03 - Using OR conditions in IF statements in VBA 11:23 - Using AND conditions in IF statements in VBA ------------------------------------------------------------------------------------- #ExcelVBA #ExcelTips #ExcelTutorial