Part 1. See 12 different examples of how to use the IF function. This video starts...
Playlist
Excel IF Function Formula Tricks
See many exciting topics regarding Excel's fantastic IF function! IF function formula statement Logical Test, Value If True, Value If False! See how to string IF functions together! See how to use the AND and OR functions for the Logical Test. See when to switch over to VLOOKUP instead of the IF function. Excel If statement formula function
Videos: 82
|
|
10:34
Part 2. See 12 different examples of how to use the IF function. This video starts...
36:40
1-4) IF function To Put Label on Income Statement. See four different Logical Test...
7:29
Topics for this video:
1)See an efficient IF function formula get beat by an even...
27:32
Learn about:
1.Comparative Operators
2.Logical TRUE FALSE formulas
3.IS functio...
5:04
See how to use the IF function and Conditional Formatting to show the words Warnin...
5:16
See how to use all the different Comparative Operators for Logical Formulas (TRUE ...
1:40
See that the IF function sees -1, 1, 10 and -1.23 as TRUE and 0 as FALSE. See this...
5:30
See how to use the IF, AND and VLOOKUP functions to deliver the words Bid, No Bid,...
10:22
Nested IF example. See how to use the TEXT function, concatenation using the Amper...
4:36
See what to do if you must have more than 7 nested IF functions: 1) Use the Ampers...
2:50
See how to create a simple If function formula that uses a logical test that invol...
2:59
See how to create a formula that will calculate the median when you have more than...
4:39
See how to create a formula that will calculate the mode when you have more than 1...
2:35
AVERAGEIF or AVERAGE IF, for Excel 2003, 2002, 2000, 1998, 1997 see how to create ...
5:23
Create a formula that will calculate the standard deviation when you have more tha...
9:25
See how to use the IF, AND and OR functions! See how to make logical formulas. You...
7:39
See how to use the IF, AND and OR functions! See how to make logical formulas. You...
10:00
Checkbook Register Magic: See how to use the IF function, Data Validation and SUMI...
10:35
See how to use the IF, AND and VLOOKUP functions. See when too many If functions i...
© 2009 YouTube, LLC