# Office 2016 25

## Excel Basics 13: IF Function Made Easy! IS Functions Too! 14 Epic Examples!!

### DESCRIPTION

Topics in this video:
(00:01) Detailed Introduction to the IF Function & Comparative Operators and Logical Tests
(08:53) IF Example #01: Your Bonus: =IF(C6 Greater Than =C11,C10,0)
(13:39) IF Example #02: In Balance?: =IF(B22=C22,”In Balance”,”NOT In Balance”)
(17:16) IF Example #03: Bonus? TRUE or FALSE?: =C4 Greater Than =\$F\$4
(17:54) IF Example #04: Bonus? “Bonus” or “No Bonus”: =IF(C11 Greater Than =\$F\$11,”Bonus”,”No Bonus”)
(18:54) IF Example #05: Bonus? 0 or \$750: =IF(C18 Greater Than =\$F\$18,\$G\$18,0)
(20:20) IF Example #06: Bonus Commission? 5% or 1%: =IF(C25 Greater Than \$F\$25,\$G\$25,\$H\$25)
(23:34) IF Example #07: Calculate Commission Paid: =IF(C32 Greater Than \$F\$32,\$G\$32,\$H\$32)*C32
(27:46) IF Example #08: “Under” or “Over”: =IF(C39 Less Than \$F\$39,\$H\$39,\$G\$39)
(31:25) IF Example #09: “No Balance” or Show Nothing: =IF(C46=0,\$H\$46,””)
(35:03) IF Example #10: Is it a Number?: =ISNUMBER(C7)
(38:26) IF Example #11: Is cell empty?: =ISBLANK(C7)
(39:09) IF Example #12: Is it Text?: =ISTEXT(C7)
(40:23) IF Example #13: Cheque book Balance: =IF(ISBLANK(B5),””,G4-F5+E5)
(48:22) IF Example #14: Sales Category: =IF(L7 Greater Than \$O\$7,”Large”,”Small”) and then make a PivotTable
(52:50) Summary – Conclusion