Download Start Excel File: https://people.highline.edu/mgirvin/AllClasses/135NoTextBook/Content/05BankingPayroll/ExcelBusinessMathVideo28IFandCheckRegister.xlsx
Download pdf Notes: https://people.highline.edu/mgirvin/AllClasses/135NoTextBook/Content/05BankingPayroll/ExcelBusinessMathVideo28IFandCheckRegister.pdf
Entire Class Web Site: https://people.highline.edu/mgirvin/AllClasses/135NoTextBook/135/135NoTextBookClass.htm
In this video learn how to build a check Register using the IF Function and the ISBLANK Function
Excel & Business Math Class (Busn 135) taught by Michael Girvin at Highline College / Mike Girvin at excelisfun Channel at YouTube Channel.
Topics in Video:
1. (00:01) Introduction
2. (01:08) Double Vertical Borders for Checkbook Register
3. (03:16) Data Validation to ONLY allow an X in the Reconciliation Column
4. (04:38) Conditional Formatting with Logical Formula and Mixed Cell Refence to format the row yellow when the item has been reconciled
5. (08:20) Checkbook Balance Formula
6. (11:07) First look at the IS Function: ISNUMBER
7. (14:07) First look at the IF Function
8. (15:20) Checkbook Balance Formula #1 using IF Function, ISNUMBER Function and a Zero Length Text String.
9. (16:37) First look at “Show Nothing”, Double Quote, Double Quote, Zero Length Text String.
10. (18:06) Test IF Function. Use Formula Evaluator to see how the IF Function puts One of Two Things in the cell.
11. (21:00) Checkbook Balance Formula #2 using IF Function, ISBLANK Function and a Zero Length Text String
12. (24:48) Difference between using ISNUMBER or ISBLANK for the Logical Test.
13. (25:38) ISFORMULA & FORMULATEXT to show formula when formula is entered into a cell.
14. (28:35) Test to see if Zero Length Text String is in cell using the ISBLANK, ISTEXT and LEN Functions
15. (30:44) Summary

Next Video: 29 Excel & Business Math