Completed
) Conditional Formatting with Logical Formula and Mixed Cell Refence to format the row yellow when the item has been reconciled
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
