Select Page

Adding If statements makes your code much more powerful. I’ll show you how to start using If statements in Excel Video 435. We’ll work through two examples to start. The first example is a simple If statement that fits on one line. Notice the If clause contains a test for Excel to evaluate true or false. The Then clause tells Excel what to do when the If clause is true.
When we tell Excel to do more than thing (bold and red) in the Then clause, notice how the structure changes and we add an End If statement at the end. We’ll build on this structure to make the If statement a little more complex in the next Excel Video. I look forward to seeing you then.