Excel 2016 Basics Free Course - Learn to Efficiently Use Excel at Work and to Get a Job. - Excel Basics 13: IF Function Made Easy! IS Functions Too! 14 Epic Examples!!

Highline College Busn 216 Class: Computer Applications taught by Michael Girvin. Download Excel Start & Finished File: https://people.highline.edu/mgirvin/AllClasses/216v2016/Content/04Excel/EB13-IF-FunctionAnd-IS-Functions.xlsm Download Full Written Notes: https://people.highline.edu/mgirvin/YouTubeExcelIsFun/Office2016Class25-ExcelBasics13-IF-FunctionAndIs-Function.pdf Class web page link: https://people.highline.edu/mgirvin/AllClasses/216v2016/Content/04Excel/Excel2016.htm Topics in this video: 1. (00:01) Detailed Introduction to the IF Function & Comparative Operators and Logical Tests 2. (08:53) IF Example #01: Your Bonus: =IF(C6 Greater Than =C11,C10,0) 3. (13:39) IF Example #02: In Balance?: =IF(B22=C22,"In Balance","NOT In Balance") 4. (17:16) IF Example #03: Bonus? TRUE or FALSE?: =C4 Greater Than =$F$4 5. (17:54) IF Example #04: Bonus? "Bonus" or "No Bonus": =IF(C11 Greater Than =$F$11,"Bonus","No Bonus") 6. (18:54) IF Example #05: Bonus? 0 or $750: =IF(C18 Greater Than =$F$18,$G$18,0) 7. (20:20) IF Example #06: Bonus Commission? 5% or 1%: =IF(C25 Greater Than $F$25,$G$25,$H$25) 8. (23:34) IF Example #07: Calculate Commission Paid: =IF(C32 Greater Than $F$32,$G$32,$H$32)*C32 9. (27:46) IF Example #08: "Under" or "Over": =IF(C39 Less Than $F$39,$H$39,$G$39) 10. (31:25) IF Example #09: "No Balance" or Show Nothing: =IF(C46=0,$H$46,"") 11. (35:03) IF Example #10: Is it a Number?: =ISNUMBER(C7) 12. (38:26) IF Example #11: Is cell empty?: =ISBLANK(C7) 13. (39:09) IF Example #12: Is it Text?: =ISTEXT(C7) 14. (40:23) IF Example #13: Checkbook Balance: =IF(ISBLANK(B5),"",G4-F5+E5) 15. (48:22) IF Example #14: Sales Category: =IF(L7 Greater Than $O$7,"Large","Small") and then make a PivotTable 16. (52:50) Summary - Conclusion