Excel Magic Trick 31.5 IF, Data Validation, SUMIF
ExcelIsFun
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!
|
|
| Screencast Tags | | bank, checkbook, College, Community, Data, Excel, function, Gel, Girvin, Highline, IF, Mike, reconciling, register, SUMIF, Validation |
| |
Digg
Del.icio.us
Reddit
Spurl
Squidoo
Yahoo
Google
