Excel IF Formula: Simple to Advanced (multiple criteria, nested IF, AND, OR functions) PART 1
Excel IF Formula: Simple to Advanced (multiple criteria, nested IF, AND, OR functions) PART 1
EXCELKICLASS PLAYLIST - • Excelkiclass
Learn how to use Excel's IF Function in your reports.
We cover a few examples in this tutorial including:
1. Simple IF function (also with greater than or less than checks).
2. IF Formula together with AND logical test to decide outcome if more than one condition is met.
3. Nested IF formula (an IF inside another IF) to check for multiple criteria.
4. IF formula with OR function (to check if "either" condition is met and then decide the outcome).
5. We also take a look at using formulas (other calculations) inside the IF function and finally:
EXCEL BASIC PLAYLIST - • EXCEL BASIC
Don't forget to like the video if you find it helpful, and subscribe to our channel for more tutorials on ExcelKiClass,
ExcelKiClass -
[Links to your social media or website, if applicable]
SUM SUMIF SUMIFS - • SUM , SUMIF, SUMIFS Function in Excel in H...
AVG AVGIF AVGIFS - • AVERAGE AVERAGEIF AVERAGEIFS Function IN E...
COUNT COUNTIF COUNTIFS - • MS EXCEL COUNT COUNTA COUNTIF COUNTIFS COU...
VLOOKUP FORMULA - • How To Use VLOOKUP Formula in Microsoft Ex...
HLOOKUP FORMULA - • How To Use HLOOKUP Formula in Microsoft Ex...
INDEX MATCH FORMULA - • INDEX MATCH FUNCTION IN EXCEL | DON'T USE ...
Follow Me (Amit Verma) on ExcelKiClass :
youtube ► / @excelkiclass3424
Instagram► https://www.instagram.com/excelkiclas...
linkedIn ► / excelkiclass
Facebook► / excelkiclasss
FBGroup ► / 905573093419037
FBPage ► / excelkiclass
हर रोज नया वीडियो ट्यूटोरियल हिन्दी में पाने के लिये हमारा यूट्यूब चैनल सबस्क्राइब करें और घर बैठे ही जॉइन करें ExcelKiClass ko 👈