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

Part 2. See 12 different examples of how to use the IF function. This video starts with IF function basics and then shows 12 different examples of how the IF function can be used in formulas. Also see these functions: AND, OR, SUM, AVEARAGE, STDEVP, and VLOOKUP.
See how to use the IF function to put:

1 of 2 numbers in a cell or formula.
1 of 2 words in a cell or formula.
1 of 2 text strings in a cell or formula.
1 of 2 formulas in a cell or formula.
1 of 2 functions in a cell or formula.
1 of 2 cell ranges in a cell or formula.
How to have more than one IF (Nested IF Ifs).
When to switch to the VLOOKUP function.
How to build multiple criteria formulas with the IF function.
How to use the AND function with the IF function.
How to use the OR function with the IF function.

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

Category:

Science & Technology

Tags:

• Excel
• IF
• function
• formula
• AND
• OR
• SUM
• AVEARAGE
• STDEVP
• VLOOKUP
• Mike
• Gel
• Girvin
• Highline
• Community
• College

[thisisouraccount]

these r really best videos and u r best man

[ExcelIsFun]

I am glad that the videos help!

[Sailor33195]

Thanks for all you do.

I really appreciate these tutorials.

I enjoy the enthusiasm . . . and speed.

Cheers!

[ExcelIsFun]

You are welcome!

[Sailor33195]

Thanks for all you do.

I really appreciate these tutorials.

I enjoy the enthusiasm . . . and speed.

Cheers!

[ExcelIsFun]

You are welcome!

[lera5266]

BBrrilliant!!!



[vrocavesna]

It's a facbook badge connector. You can create it on your fb page, and the post it in your web page, so if someone is click on it, this badge connect him to FB.

Hope that will post :)

[vrocavesna]

@ExcelIsFun

It's a facbook badge connector. You can create it on your fb page, and the post it in your web page, so if someone is click on it, this badge connect him to FB.

[vrocavesna]

@ExcelIsFun

It's a facbook badge connector. You can create it on your fb page, and the post it in your web page, so if someone is click on it, this badge connect him to FB.