Excel 2016 IFS Functions - Compare and Contrast IF and IFS Functions

Explore the powerful new Excel 2016 IFS Function through nine practical examples in this comprehensive 28-minute video tutorial. Learn how to effectively use IFS for situations with three or more conditions where VLOOKUP falls short. Compare and contrast IF and IFS functions, create income statement labels, handle unusual lookup situations, and understand error handling. Discover techniques for setting default values, interpreting logical test arguments, and using IFS to implement formula lookups. Gain insights into when nested IF functions are still necessary and explore alternative functions like CHOOSE, VLOOKUP, and SWITCH. Download the accompanying Excel files to practice alongside the instructor and master this versatile Excel feature.

) Introduction to what IFS functions does. IFS is great for when you have 3 or more items to put into a cell..
) Create Income Statement Labels: Profit, Loss or Break Even. Compare and contrast IF function and IFS function. Also see ABS function..
) 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..
) Why #N/A Error shows up with the IFS Function. See that the Nested IF function method does not yield #N/A errors..
) How to put a default value into the IFS function using the “Last logical_test argument TRUR Trick”.
) Compare IF and IFS and how the logical_test arguments interprets values..
) Use IFS functions to put 1 of 4 different formulas in a cell. Lookup a formula trick!.
) 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..
) 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..