Select Page

Excel Video 437 More Complex If Statements

The pre-authorization example gets even more precise in Excel Video 437, the last Excel Video about If. We’ll add several different tests to make different pre-authorization scenarios different colors in this Excel Video, including And tests and Or tests. We’ll also...

Excel Video 436 Else and ElseIf

You can add more power to your If statements by using Else and ElseIf. Excel Video 436 has an example of both. The If statements we worked through in the last Excel Video tested to see if the insurance was not Medicare. If the insurance is Medicare, we can use an Else...

Excel Video 435 If Statements

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...

Excel Video 434 Message Boxes Part 3

In Excel Video 434 we’ll work through how to capture user input from Message Boxes. Notice how the syntax is slightly different when we need the user’s answer. We define a variable as equal to the Message Box and the Message Box function now needs parentheses. The...