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

Part 1. 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 If statement

Excel Magic Trick 165p2 MACRO Advanced Filter Extract B-days

Other amazing videos at YouTube: Excel Trick, Making a Gantt Chart with Excel, Recording Macros - Excel 2003, VLOOKUP in Excel 2007.

Category:

Science & Technology

Tags:

• Excel
• IF
• function
• formula
• statement
• AND
• OR
• SUM
• AVERAGE
• VLOOKUP
• Mike
• Gel
• Girvin
• Highline
• Community
• College

[llnicholsii]

Excellent video!!! Is there a way to have two IF logical functions with with two different true responses and two different false responses?

E.g. IF(AND(A1=B1,"Ok",IF(A1<0,"-1"­,IF(B1<0,"+1,"Bad")))

[ExcelIsFun]

@llnicholsii , yes, post questions to THE best Excel question site:

mrexcel [dot] com/forum

[jonjon72886]

How do I write a command which will say the following. If a cell is greater than zero move down one row, if not delete row.

[ExcelIsFun]

You may need VBA for that. Post Q to:

mrexcel [dot] com/forum

[MariooTX]

How would you incorporate %'s into these type of formulas? For example, my professor threw this in at the end of the assignment:

Add a delivery charge to customer totals: 10% if over $200;otherwise 15%

I keep wanting to put "=IF(H2>$200,10% of H2,15% of H2)"

H2 is $81.50

Obviously, I know I cant put the word "of" and expect it to work so I'm confused about the the correct formatting.

[ExcelIsFun]

Try something like:

=IF(H2>200,1.1*H2,1.15*H2)

[LuluNero]

You are a WONDERFUL TRAINER.

I am happy to have found someone who teaches with such passion. One wants to listen to your classes (and one doesnt get half asleep or lost btw). Your tricks are very detailed (which I like) and easy to follow. Thanks for doing what you do.

[ExcelIsFun]

I do not understand your question.

[nikhilkhandelwal0311]

@ExcelIsFun

please give formula for this condition

[bootz2boobz]

I am still confused trying to calculate IF function.Any student worker who works 18 hours or less will have the pay applied to his or her tuition. If a student works more than 18 hrs (referenced in F7), then student will receive a paycheck for hours over 18. In cell D11, construct an IF function to determine the number of hours worked that will be applied to the student’s tuition using cell F7 as an absolute reference. Cell F6 Hourly Rate=$9.75,F7=18. Cell C11: 18,39,22,16,27,20,32,16,11,47,­54

[MariooTX]

@ExcelIsFun Hey Thanks so much!! That worked out great!!

[leftylee527]

Yeah! It worked! You are the BEST! Thank you, thank you, thank you!