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.