DON'T Do THIS with Excel IF Formulas!

UPDATE: the Advanced Formula Environment is now found in the Excel Labs add-in. Avoid making these mistakes when writing IF formulas in Excel. ⬇️ Download the example file here and follow along: https://bit.ly/ifmistakes25file 👩‍🏫 Join my Excel & Power BI courses: https://bit.ly/ifmistakes25courses LEARN MORE =========== 📰 EXCEL NEWSLETTER - join 450K+ subscribers here: https://www.myonlinetraininghub.com/e... 🎯 FOLLOW me on LinkedIn:   / myndatreacy   💬 EXCEL QUESTIONS: Get help on our Excel Forum: https://www.myonlinetraininghub.com/e... ⏲ TIMESTAMPS ============== 0:00 Mistakes when writing nested IF formulas in Excel 0:39 The Ridiculous IF Formula 1:03 Advanced Formula Environment 3:36 Remove CEILING Functions 4:17 Replace cell references with Structured References 5:34 Identify Criteria 7:40 Improved Formula without any IFs 11:06 Lessons Learned #Excel #ExcelFunctions #ExcelFormulas