У нас вы можете посмотреть бесплатно Stop Using AND/OR in Excel! Use * and + Instead 🚀 (XLOOKUP, FILTER, INDEX MATCH) или скачать в максимальном доступном качестве, видео которое было загружено на ютуб. Для загрузки выберите вариант из формы ниже:
Если кнопки скачивания не
загрузились
НАЖМИТЕ ЗДЕСЬ или обновите страницу
Если возникают проблемы со скачиванием видео, пожалуйста напишите в поддержку по адресу внизу
страницы.
Спасибо за использование сервиса ClipSaver.ru
Stop overcomplicating your Excel formulas with AND() and OR(). In this tutorial, I’ll show you a simpler way: using * (multiply) and + (add) as logic operators inside formulas. By converting TRUE/FALSE into 1s and 0s, you can unlock powerful dynamic array formulas that spill results, handle multiple criteria, and make your spreadsheets cleaner. 🔑 What you’ll learn in this video: ✅ Why * works as AND and + works as OR in Excel ✅ How Boolean logic becomes 1s and 0s behind the scenes ✅ How to supercharge XLOOKUP with multiple conditions ✅ How to use INDEX MATCH / XMATCH with array logic ✅ How to spill multiple results with FILTER ✅ How to aggregate with SUMPRODUCT ✅ Why AND() and OR() break with arrays — and why * and + solve it Perfect for Excel beginners and advanced users who want to simplify formulas and unlock the power of Boolean logic with dynamic arrays. ⏱️ Timestamps: 00:00 - Intro 00:24 - Boolean to Binary results 01:42 - XLOOKUP with AND logic (binary arrays) 05:32 - XLOOKUP with OR logic (binary arrays) 08:23 - INDEX XMATCH with multiple criteria 09:57 - FILTER with multiple criteria 10:35 - SUMPRODUCT with multiple criteria 11:29 - * vs + compared to AND/OR functions 14:00 - Final thoughts 💬 Try these tricks on your own spreadsheets and tell me in the comments what problems they help you solve! 🙌 Support the Channel: 👍 Like the video 💬 Leave a comment 🔁 Share with a friend 💸 https://buymeacoffee.com/benjones - to support the channel 📁File https://buymeacoffee.com/benjones/e/4... 🔔 SUBSCRIBE FOR WEEKLY TUTORIALS Subscribe to BenJonesExplains Click here to subscribe and master Excel, one trick at a time! / @benjonesexplains @BenJonesExplains 🔍 Tags / Hashtags: #Excel #ExcelTips #ExcelFormulas #XLOOKUP #IndexMatch #FilterFunction #SUMPRODUCT #DynamicArrays #ExcelLogic #ExcelANDOR #ExcelMultipleCriteria #BooleanLogic #ExcelHacks #ExcelShortcuts #ExcelTutorial