Excel & Business Math - IF Function, IS Functions & Building a Check Register and Other IF Tricks

Overview

Learn to build a comprehensive check register in Excel using advanced functions like IF and ISBLANK in this 32-minute tutorial video. Master essential skills including creating double vertical borders, implementing data validation, applying conditional formatting, and constructing complex checkbook balance formulas. Explore the nuances of IS functions, discover the power of zero-length text strings, and utilize the Formula Evaluator to understand IF function mechanics. Gain practical insights into ISFORMULA, FORMULATEXT, and techniques for testing cell contents. Download accompanying materials to follow along and enhance your Excel proficiency for business math applications.

Syllabus

) Introduction.
) Double Vertical Borders for Checkbook Register.
) Data Validation to ONLY allow an X in the Reconciliation Column.
) Conditional Formatting with Logical Formula and Mixed Cell Refence to format the row yellow when the item has been reconciled.
) Checkbook Balance Formula.
) First look at the IS Function: ISNUMBER.
) First look at the IF Function.
) Checkbook Balance Formula #1 using IF Function, ISNUMBER Function and a Zero Length Text String..
) First look at “Show Nothing”, Double Quote, Double Quote, Zero Length Text String..
) Test IF Function. Use Formula Evaluator to see how the IF Function puts One of Two Things in the cell..
) Checkbook Balance Formula #2 using IF Function, ISBLANK Function and a Zero Length Text String.
) Difference between using ISNUMBER or ISBLANK for the Logical Test..
) ISFORMULA & FORMULATEXT to show formula when formula is entered into a cell..
) Test to see if Zero Length Text String is in cell using the ISBLANK, ISTEXT and LEN Functions.
) Summary.