Excel Magic Trick #31.5 IF, Data Validation, SUMIF

Back


Checkbook Register Magic: See how to use the IF function, Data Validation and SUMIF to make an amazing Checkbook Register that automatically reconciles your Bank Account! IF function to turn formulas on and off by checking to see whether or not a cell is blank. Data Validation to allow only negative numbers in 1 column and only the reconciling symbol "y" in another column SUMIF to automatically reconcile the bank account to see what the Bank balance should be!

Category: Tech
Uploaded: March 24th, 2008 @ 5:46 pm
Author: ExcelIsFun

Length: 10:00
Rating: Whole StarWhole StarWhole StarWhole StarHalf Star
Views: 5,749

Tags: bank checkbook college community data excel function gel girvin highline if mike reconciling register sumif validation

Related Video Links:


» View Video Comments For Excel Magic Trick #31.5 IF, Data Validation, SUMIF
» View ExcelIsFun's Other Uploaded Videos

Video Thumbnails:


Thumbnail #1 Video Thumbnail #1:
Thumbnail #2 Video Thumbnail #2:
Thumbnail #3 Video Thumbnail #3:


Video Embedding Code:


Video Url:


Embed Code:

* Embed this video on your website, social bookmark, myspace, or blog.