The AND Function in Excel is Broken – Here's How to Fix It!

★ Want to automate Excel? Check out our training academy ★ exceloffthegrid.com/academy ★ Get the example file ★ Sign up for our free Insiders program and get the example file: exceloffthegrid.com/insiders-signup/ File Reference for this video: 0230 AND OR broken.zip ★ About this video ★ If you've ever tried to use the AND or OR functions with dynamic array calculations, you'll know they don't work. So, are AND and OR broken, or do we just not understand how they work? The good news is, there is a solution which we look at in 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:20 How AND actually works 1:48 Solution 1: MAP/LAMBDA 3:15 Solution 2: Avoiding AND 4:50 Solution 3: Avoiding IF 5:38 Wrap up ★ Download 30 most useful Excel VBA Macros ebook for FREE ★ exceloffthegrid.com/ ★ Where to find Excel Off The Grid ★ Blog: exceloffthegrid.com/ Twitter: twitter.com/exceloffthegrid #MsExcel