Billing Statement

See how to use the IF, AND and OR functions! See how to make logical formulas. You can check to see if a cell is blank, whether it is above a certain limit, or whether the cell contains text!

See how to make the labels on your Income Statement change depending on whether or not there is a Net Loss or a Net Income. See how to use the IF, AND, and OR function to evaluate a customer’s credit.

Excel Magic Trick 167p1 IF function formula: 12 Examples!

Excel Magic Trick 167p2 IF function formula: 12 Examples!

Duration : 0:7:39

(more…)

Using an IF Statement to Validate text placed in a text box on button press:

Here’s the code I used in this:

Dim Captain As String

Captain = TextBoxCaptain.Text
Captain = Captain.ToUpper

If Captain = “PICARD” Or Captain = “KIRK” Or Captain = “ARCHER” Or Captain = “PIKE” Or Captain = “JANEWAY” Then

MsgBox(”Indeed, Warp Factor 9!”)
Else
MsgBox(Captain & ” has never been a Captain”)
End If

Have fun!

Duration : 0:7:25

(more…)

I explain how to use a Select Case statement using a ComboBox and a button

Duration : 0:2:52

(more…)