IF with multiple criteria (using the IFS function)
Replace (some) nested IF functions with the "new" IFS function - including examples and how to troubleshoot.
🕒 TIMESTAMPS
0:00 How to use IFS
1:55 How to troubleshoot IFS
👍 LIKE AND SUBSCRIBE
If you found this video helpful, hit 'Like' and 'Subscribe' to never miss our latest tutorials. Got a question or feedback? Write a comment!
🎁FREE COURSES
Try my free 30-minute Excel course and join 100,000+ students: https://spreadsheeto.com
Learn Power BI for free and create impactful reports in just 30 minutes: https://spreadsheeto.com/free-power-b...
🏆PAID COURSES
Zero to Hero. From beginner to Excel expert in 14 hours: https://spreadsheeto.com/zero-to-hero/
VBA Masterclass. Become a VBA pro in 20 hours: https://spreadsheeto.com/vba-mastercl...
Power BI Essentials. Master Power BI in 12 hours: https://spreadsheeto.com/power-bi/
🧑💻HIRE ME AND MY TEAM
We develop custom Excel systems: https://spreadsheeto.com/excel-consul...