Excel Forum
Similar Content
Calculate Hours Worked - Day or Night Shift & Breaks in Excel
Tutorial: Single simple formula to calculate the hours worked for a day shift or night shift and inc...
Odd or Even Row Formulas in Excel
Tutorial: Formulas to determine if the current cell is odd or even; this allows you to perform speci...
Formula to Delete the First or Last Word from a Cell in Excel
Tutorial: Excel formula to delete the first or last word from a cell. You can copy and paste the fo...
Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course



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!





Got a Question? Ask it Here in the Forum.