⚡ GET THE EXCEL TEMPLATE HERE: [ Ссылка ]

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

✅ 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 ► [ Ссылка ]

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

MY FAVORITE OFFICE GEAR*
🖥️ My LG curved ultra-widescreen monitor: [ Ссылка ]
🐭 My Logitech wireless mouse MX Master: [ Ссылка ]
🎧 My Bose noise cancelling earphones: [ Ссылка ]
🔊 My Jabra speaker for video conferences: [ Ссылка ]
💻 My Lenovo Thinkpad X1 Carbon workhorse notebook: [ Ссылка ]
🛋️ My BenQ ScreenBar: [ Ссылка ]
🆙 My height adjustable standing desk: [ Ссылка ]
💡 My Philips Hue smart light bars: [ Ссылка ]

MY FAVORITE SOFTWARE/TOOLS*
📊 Microsoft 365: [ Ссылка ]
🔊 Where I listen to 30+ audio books per year: [ Ссылка ]

* 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

свернуть