STOP using nested IF statements! Use these functions instead.

★ Want to automate Excel? Check out our training academy ★ https://exceloffthegrid.com/academy ★ Get the example file ★ Sign up for our free Insiders program and get the example file: https://exceloffthegrid.com/insiders-signup/ File Reference for this video: 0229 Stop nested IF.zip ★ About this video ★ If we use nested IF statements, it's not long until they are out of control and difficult to understand. So, in this video, we look at the easier alternatives we can use to keep our formulas understandable. 0:00 Introduction 0:19 Scenario 0:48 Nested IF statement 2:08 IFS function 4:26 SWITCH function 6:01 Lookup Table + XLOOKUP function 8:08 Which method to use? 8:43 Wrap up ★ Download 30 most useful Excel VBA Macros ebook for FREE ★ https://exceloffthegrid.com/ ★ Where to find Excel Off The Grid ★ Blog: https://exceloffthegrid.com Twitter: https://twitter.com/exceloffthegrid #MsExcel