Excel IF Formula: Simple to Advanced (multiple criteria, nested IF, AND, OR functions)
Feb 1, 2018 Excel Intermediate Functions & Features (For ALL Excel Versions)
Join 400,000+ professionals in our courses: https://www.xelplus.com/courses/
Learn how to use Excel's IF Function in your reports.
00:00 When to use the Excel IF function
00:35 When to use a Nested IF formula
00:55 Excel IF THEN formula
03:18 Excel IF formula with AND condition
05:05 Nested Excel IF formula
07:52 Excel IF formula with OR condition
09:17 Excel IF formula with threshold
11:22 Excel IF formula with symbols for result
14:29 Wrap-Up of different uses of Excel IF function
⯆ Download the workbook here: http://www.xelplus.com/excel-if-formula-simple-to-advanced/
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:
6. How to use symbols as the result of the IF formula
Your IF formula isn't working? One of the main mistakes is the "else" argument. That's the last argument inside the IF function. Make sure you haven't forgotten to specify what should happen "if" the condition isn't met. In case you have more than one condition, here's the place to add the second "if" statement. An IF formula inside another IF formula is called a nested if function.
Links to related videos:
Conditional formatting symbols: https://youtu.be/875eK_x4nyQ
Custom formatting symbols: https://youtu.be/tGY70sdpaLc
If Function with Partial text match: https://youtu.be/b9WoDkPOTPs
★ My Online Excel Courses ► https://www.xelplus.com/courses/
✉ Subscribe & get my TOP 10 Excel formulas e-book for free
https://www.xelplus.com/free-ebook/
EXCEL RESOURCES I Recommend: https://www.xelplus.com/resources/
GEAR I use: https://www.xelplus.com/resources/#gear
More resources on my Amazon page: https://www.amazon.com/shop/leilagharani
Let’s connect on social:
Instagram: https://www.instagram.com/lgharani
Twitter: https://twitter.com/leilagharani
LinkedIn: https://at.linkedin.com/in/leilagharani
Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!
#MsExcel
-
1:01:06
The StoneZONE with Roger Stone
5 hours agoWill Terrorists Take Down America's Power Grid? With Glenn Rhoades | The StoneZONE w/ Roger Stone
13K19 -
1:03:58
Edge of Wonder
5 hours agoAce Ventura: Mandela Detective, King Charles Portrait & Weird News
17.4K19 -
1:40:05
The Quartering
10 hours agoWhy Modern Women Suck w/Hoe_Math
38.7K42 -
1:43:26
Robert Gouveia
5 hours agoGarland SHAKING over CONTEMPT; Congressional MELTDOWN; Fani RAGES at Senate; Tish INVESTIGATED
32.1K52 -
1:48:05
2 MIKES LIVE
7 hours ago#67 2ML Open Mike Friday, we have a LOT to talk about!
16.5K3 -
2:27:40
WeAreChange
7 hours agoIt’s NOT Just The Frogs — They’re Turning All The Animals GAY??
56.7K33 -
1:02:40
In The Litter Box w/ Jewels & Catturd
1 day agoPolice State | In the Litter Box w/ Jewels & Catturd - Ep. 570 - 5/17/2024
73.1K54 -
1:57:17
Twins Pod
7 hours agoTwins Pod - Episode 13 - Tim Kennedy: Seals Vs Green Berets, Tigers Vs Bears, & Israel Vs Palestine
64.8K29 -
2:21:43
Tucker Carlson
1 day agoDave Smith: Russia, Israel, Trump & the Swamp, Obama, and the Media Attacks on Joe Rogan
157K392 -
59:55
shaneyyricch
7 hours agoPERMANENTLY BANNED ON YOUTUBE - LETS RUMBLE
36.3K24