Главная
Study mode:
on
1
) Detailed Introduction to the IF Function & Comparative Operators and Logical Tests
2
) IF Example #01: Your Bonus: =IF(C6 Greater Than =C11,C10,0)
3
) IF Example #02: In Balance?: =IF(B22=C22,"In Balance","NOT In Balance")
4
) IF Example #03: Bonus? TRUE or FALSE?: =C4 Greater Than =$F$4
5
) IF Example #04: Bonus? "Bonus" or "No Bonus": =IF(C11 Greater Than =$F$11,"Bonus","No Bonus")
6
) IF Example #05: Bonus? 0 or $750: =IF(C18 Greater Than =$F$18,$G$18,0)
7
) IF Example #06: Bonus Commission? 5% or 1%: =IF(C25 Greater Than $F$25,$G$25,$H$25)
8
) IF Example #07: Calculate Commission Paid: =IF(C32 Greater Than $F$32,$G$32,$H$32)*C32
9
) IF Example #08: "Under" or "Over": =IF(C39 Less Than $F$39,$H$39,$G$39)
10
) IF Example #09: "No Balance" or Show Nothing: =IF(C46=0,$H$46,"")
11
) IF Example #10: Is it a Number?: =ISNUMBER(C7)
12
) IF Example #11: Is cell empty?: =ISBLANK(C7)
13
) IF Example #12: Is it Text?: =ISTEXT(C7)
14
) IF Example #13: Checkbook Balance: =IF(ISBLANK(B5),"",G4-F5+E5)
15
) IF Example #14: Sales Category: =IF(L7 Greater Than $O$7,"Large","Small") and then make a PivotTable
16
) Summary - Conclusion
Description:
Dive into a comprehensive 54-minute video tutorial on mastering Excel's IF function and IS functions. Learn through 14 practical examples, including bonus calculations, balance checks, commission computations, and sales categorizations. Explore comparative operators, logical tests, and functions like ISNUMBER, ISBLANK, and ISTEXT. Conclude with creating a PivotTable based on sales categories. Access downloadable start and finished Excel files, along with detailed written notes, to enhance your learning experience.

Excel Basics - IF Function Made Easy and IS Functions Too - Epic Examples

ExcelIsFun
Add to list
#Business #Business Software #Microsoft Office 365 #Microsoft Excel #Data Science #Data Analysis #Spreadsheets #PivotTables
0:00 / 0:00
1 of 16

) Detailed Introduction to the IF Function & Comparative Operators and Logical Tests