Completed
) IFS function to put the text Sunday, Saturday or Weekday into a cell. Also see the other Excel Function options: CHOOSE function, VLOOKUP function and the new Excel 2016 SWITCH function.
Class Central Classrooms beta
YouTube videos curated by Class Central.
Classroom Contents
Excel 2016 IFS Functions - Compare and Contrast IF and IFS Functions
Automatically move to the next video in the Classroom when playback concludes
- 1 ) Introduction to what IFS functions does. IFS is great for when you have 3 or more items to put into a cell.
- 2 ) Create Income Statement Labels: Profit, Loss or Break Even. Compare and contrast IF function and IFS function. Also see ABS function.
- 3 ) Use IFS function when you have an unusual Lookup situation. Commission Example to get 1 of 4 commission rates. See when you should use VLOOKUP and when it is better to use IFS function.
- 4 ) Why #N/A Error shows up with the IFS Function. See that the Nested IF function method does not yield #N/A errors.
- 5 ) How to put a default value into the IFS function using the “Last logical_test argument TRUR Trick”
- 6 ) Compare IF and IFS and how the logical_test arguments interprets values.
- 7 ) Use IFS functions to put 1 of 4 different formulas in a cell. Lookup a formula trick!
- 8 ) Nested IF functions are still needed for Aggregate Function Array Formulas such as the Standard Deviation formula with multiple criteria that uses the STDEV.S function.
- 9 ) IFS function to put the text Sunday, Saturday or Weekday into a cell. Also see the other Excel Function options: CHOOSE function, VLOOKUP function and the new Excel 2016 SWITCH function.
