10 Advanced IF formulas every analyst should know

Almost 70% of spreadsheets contain IF formula. So how well do you know it? In this *ADVANCED* video, learn all about:

-- Using IF to check ONLY One of condition
-- Any Two out of Three conditions
-- Between condition with MEDIAN function
-- Replacing nested if formulas with *NEW* IFS function
-- Speeding up IF logic with Boolean replacement hack
-- Check List membership
-- Using Arrays with if (MedianIF example)
-- Wildcard comparisons in IF formula
-- Using IF with Conditional Formatting
-- IF + Charts for awesome results

Timestamps:
===========

0:00 - Intro
0:25 - Only One of condition (XOR)
2:12 - Any two out of three conditions
4:58 - Between formula (AND method & MEDIAN method)
7:00 - Nested IF replacement with IFS()
9:03 - Pop Quiz
9:16 - Avoiding IF formulas with Boolean Replacement Hack
11:42 - List membership check with IF formula
13:35 - Using Arrays with IF - Median IF example
16:10 - Wildcard check with IF
17:45 - Conditional formatting with IF
19:48 - Charts with IF formula
21:23 - Closing remarks

Example files:
===========

👉Checkout my online course on Advanced Excel & Data analysis
===================================================

#IFLove #Excel

[Maheshwaripn]

Following you on website for years and today I found you here, immediately subscribed
Your examples are like patented inventions for free

[roderickmose]

=IF("excellent learning needed"="yes", "Chandoo", "")

[AnuragSingh-fpei]

Chandoo, I have been following you since more than a decade now. Thanks once again for awesome tips and tricks!! These are so useful

[erickowaga]

I've struggled with the IF function for too long before I came across your channel. You're awesome. Thanks for the great stuff.

[MrRanjithm]

You are really superb Chandoo. Coming from the Indian dub continent at 74 years, I started following your tips, and I have understood these formulas much more than before, and I can use them in many of my worksheets I do for a school. Thank you very much.

[srinivasraogampala]

I am using nested if function for lot of years. Now I came to know that there is a IFS function, much readable code.. You are awesome bro.

[mikelib]

you have a knack of making a difficult, look so simple and matter of fact- you are indeed one of the best on this subject

[akilj]

Hello Chandoo, your content is amazing. I love the way you take time and explain every part of the Function / Formula. Thanks a million. You are the best!!

[taizoondean]

Was revising Thank You again and God Bless You

[ktothemoon]

How come is this free stuff on youtube? This is gem! Thanks for the awesome tips and tricks! Instantly subscribed.

[m.raedallulu]

I've been following you since nearly three years, and you are a wonderful Excel person, Chandoo!
Thank you so much!

[derrickpeoples]

Chandoo, you saved my life! I had to use your second example (i.e., Any two out of three conditions) in a real world work assignment, and I got the solution I was looking for, :)

[NodictatorsinKZ]

You're the best in explaining Excel! Love your channel and your videos, please keep us the good work. Love it.

[ishyamkumar]

Chandoo Sir Thank you very much for your valuable training videos, Its really useful in my carrier,

[sandipgumtya]

Hi Chandoo, thanks for the amazing tips. Many of these were unknown. Just found that the "on-call" thing can be done with the below formula too.
=IF(OR(C8=$C$32:$C$36), "On Call", "Not On Call").
Thanks

[shivsharma]

So thankful to youtube and creators like you, who making this great knowledge available for free which we would not able to access if there was no youtube.

[Me-owrw]

I already learnt from you through your online course. You are Awesome.

[iQuMaster]

There is IFS function?!! Man you just made my life so much easier 😄

[dilansenn]

Thank you very much Sir, I was struggling to use the IF function with wildcards on a major project I was stucked for a long time, this video was a life saver to over come that. Thanks loads and please keep doing this brilliant work. Wish you all the best. God bless you.

[KannadatiBindyaChannel]

Hi Guru, Thanks for your IF and only IF TIPS....!!!! using the IF function for almost a decade from you... the Advanced TIPS to use excel extensively and wisely. keep Going ...!!!