It will then make the necessary true/false decisions.
The input to the IF statement uses conditional statements such as Greater Than or Less Than. If the input condition is true, it will perform a specific result and if the condition is false, it will perform a different result. "If" statements are used to define logical true/false operations of a statement requiring several possible outcomes. The courseware is available on Amazon at: You will be able to follow along with the courseware while watching this video.Ĭourseware: Excel 365 – Visual Basic For Excel Click the Share button so you can help others expand their skills.Įach video provides a great overview of the concepts, but the courseware provides additional details for a better understanding. Click Subscribe so you won’t miss out on any new videos. Higher Quality Video: - Click + Rumble if the video was helpful. Each video can be downloaded and freely distributed to anyone desiring to learn Excel in great depth. These videos are labeled in order beginning with Part 1, 2, 3, 4, etc.
Video Series Part 36- This is a comprehensive guide to learning Excel from the basics to advanced programming techniques.
In this chapter, you will learn about "If" structure, Math operators, Comparison operators, Logical operators, and Select Case statements. Another technique to perform many decisions in a single command are the Select Case statements which will also be covered. This automated decision process will reduce human errors and increase overall accuracy. Rumble - "If" statements are used to define logical true/false operations of a statement requiring several possible outcomes.