Excel & Business Math 28: IF Function, IS Functions & Building a Check Register Other IF Tricks too скачать в хорошем качестве

Excel & Business Math 28: IF Function, IS Functions & Building a Check Register Other IF Tricks too

Download Start Excel File: https://people.highline.edu/mgirvin/A... Download pdf Notes: https://people.highline.edu/mgirvin/A... Entire Class Web Site: https://people.highline.edu/mgirvin/A... In this video learn how to build a check Register using the IF Function and the ISBLANK Function Excel & Business Math Class (Busn 135) taught by Michael Girvin at Highline College / Mike Girvin at excelisfun Channel at YouTube Channel. Topics in Video: 1. (00:01) Introduction 2. (01:08) Double Vertical Borders for Checkbook Register 3. (03:16) Data Validation to ONLY allow an X in the Reconciliation Column 4. (04:38) Conditional Formatting with Logical Formula and Mixed Cell Refence to format the row yellow when the item has been reconciled 5. (08:20) Checkbook Balance Formula 6. (11:07) First look at the IS Function: ISNUMBER 7. (14:07) First look at the IF Function 8. (15:20) Checkbook Balance Formula #1 using IF Function, ISNUMBER Function and a Zero Length Text String. 9. (16:37) First look at “Show Nothing”, Double Quote, Double Quote, Zero Length Text String. 10. (18:06) Test IF Function. Use Formula Evaluator to see how the IF Function puts One of Two Things in the cell. 11. (21:00) Checkbook Balance Formula #2 using IF Function, ISBLANK Function and a Zero Length Text String 12. (24:48) Difference between using ISNUMBER or ISBLANK for the Logical Test. 13. (25:38) ISFORMULA & FORMULATEXT to show formula when formula is entered into a cell. 14. (28:35) Test to see if Zero Length Text String is in cell using the ISBLANK, ISTEXT and LEN Functions 15. (30:44) Summary Next Video: 29 Excel & Business Math