⚡ 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
IF AND OR Formula in Excel with MULTIPLE CONDITIONS
Теги
if and or formula in excel with multiple conditionsif and or function excel combinationif and or function excel multiple conditionsif and or nested function in excelhow to test several conditions in Excelhow to test several true conditions in ExcelExcel how to test if at least one condition is trueexcel if formulaexcel if functionexcel if and ornested if formulaif and or formula in excelif or and function combinationif multiple criteriaexcel tutorial