⚡ 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 stepbystep 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 ultrawidescreen 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