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…)

http://www.TeachExcel.com
How to use a basic IF statement in Excel and also how to use a nested IF statement in Excel. This is a good tutorial for a beginner and also someone looking to understand nested IF statements.

To get the Excel file used here, go to the website and download it:
http://www.TeachExcel.com

Duration : 0:9:4

(more…)