Completed
) Checkbook Balance Formula #1 using IF Function, ISNUMBER Function and a Zero Length Text String.
Class Central Classrooms beta
YouTube videos curated by Class Central.
Classroom Contents
Excel & Business Math - IF Function, IS Functions & Building a Check Register and Other IF Tricks
Automatically move to the next video in the Classroom when playback concludes
- 1 ) Introduction
- 2 ) Double Vertical Borders for Checkbook Register
- 3 ) Data Validation to ONLY allow an X in the Reconciliation Column
- 4 ) Conditional Formatting with Logical Formula and Mixed Cell Refence to format the row yellow when the item has been reconciled
- 5 ) Checkbook Balance Formula
- 6 ) First look at the IS Function: ISNUMBER
- 7 ) First look at the IF Function
- 8 ) Checkbook Balance Formula #1 using IF Function, ISNUMBER Function and a Zero Length Text String.
- 9 ) First look at “Show Nothing”, Double Quote, Double Quote, Zero Length Text String.
- 10 ) Test IF Function. Use Formula Evaluator to see how the IF Function puts One of Two Things in the cell.
- 11 ) Checkbook Balance Formula #2 using IF Function, ISBLANK Function and a Zero Length Text String
- 12 ) Difference between using ISNUMBER or ISBLANK for the Logical Test.
- 13 ) ISFORMULA & FORMULATEXT to show formula when formula is entered into a cell.
- 14 ) Test to see if Zero Length Text String is in cell using the ISBLANK, ISTEXT and LEN Functions
- 15 ) Summary
