IF & IS Functions To Deliver Numbers, Text, Formulas, Nested IFs by
Video Lecture 15 of 50
Not yet rated
Views: 2,062
Date Added: March 14, 2015

### Lecture Description

Topics in this video:
1. IF Function to deliver numbers (00:33 min)
2. IF Function to deliver text (01:37 min)
3. IF Function to deliver formulas (03:19 min)
4. IF Function to deliver functions (05:19 min)
5. Nested IFs (07:51 min)
6. Null Text String, LEN function and ISTEXT function (10:24 min)
7. Checkbook example 1: IF functions, Null Text String and equal comparative operator (12:23 min)
8. Checkbook example 2: IF functions, Null Text String and NOT comparative operator (17:27 min)
9. Examples of IS functions in Excel: ISTEXT function, ISNUMBER function, ISLOGICAL function, ISBLANK function, ISERROR function, ISERR function, ISNA function, ISNONTEXT function, ISFORMULA (18:17 min)
10. Checkbook example 4: IF functions, ISBLANK function (19:30 min)
11. Checkbook example 5: IF functions, ISNUMBER function (20:42 min)
12. Checkbook example 6: IF functions, ISTEXT function (20:21 min)
13. Baseball data Set example IF function and COUNTIFS function (22:21 min)

### Course Description

This is the Highline Community College Class, Spreadsheet Construction taught by Michael Girvin: Basic To Advanced Excel. It contains 50 video lectures teaching the basics of Excel, as well as advanced concepts.

Be sure to download the workbook to follow along with the examples. They are found on the official course website.