⚡ GET THE EXCEL TEMPLATE HERE: https://payhip.com/b/ocaH8

▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬

✅ In this video you will learn how to use the IF AND OR function combination in Excel with multiple conditions.
This step-by-step Excel tutorial will show you how to use the IF function together with AND function or OR function in Excel 2019 in a variety of different combinations and with two or more conditions.
Based on the classic Excel IF formula, we will first next the AND function as well as the OR function to create IF AND OR formula to test if all of the tested conditions are true.
Second, we will extend the IF function in Excel and next OR formula and the AND formula to create IF OR AND function combination in Excel to test if at least one of several conditions is true.

🚩 TABLE OF CONTENTS
00:00 Introduction
00:32 Recap of the IF function
02:47 IF + AND function combination
06:23 IF, AND, OR function combination with multiple criteria
10:39 IF + OR function combination
13:03 IF, AND, OR function combination with multiple criteria
16:40 Comparison of IF AND function combination and IF OR Excel function combination

▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬

🔥 Want more professional PowerPoint presentation tips, slide designs & techniques?
Subscribe ►    / @presentationmastery  

▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬

MY FAVORITE OFFICE GEAR*
🖥️ My LG curved ultra-widescreen monitor: https://amzn.to/3ztOlkr
🐭 My Logitech wireless mouse MX Master: https://amzn.to/3Uao8jz
🎧 My Bose noise cancelling earphones: https://amzn.to/3UjbIWd
🔊 My Jabra speaker for video conferences: https://amzn.to/3fsyuMf
💻 My Lenovo Thinkpad X1 Carbon workhorse notebook: https://amzn.to/3WkevQE
🛋️ My BenQ ScreenBar: https://amzn.to/3WoUyIC
🆙 My height adjustable standing desk: https://amzn.to/3DxQBJ0
💡 My Philips Hue smart light bars: https://amzn.to/3TSX0W4

MY FAVORITE SOFTWARE/TOOLS*
📊 Microsoft 365: https://amzn.to/3zxnjcc
🔊 Where I listen to 30+ audio books per year: https://amzn.to/3gUOUgV

* Links are Affiliate links. This means I earn a small revenue share whenever a qualifying purchase is made via the link. The price for you stays the same = win/win 👍


#IfFunction #MultipleConditions #ExcelTutorial