### 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

### NOTES

### WORKBOOKS

Download “Office 2016 Video 25” EB13-IF-FunctionAnd-IS-Functions.xlsm – Downloaded 21 times – 2 MB

## Leave a Reply

You must be logged in to post a comment.