5 Advanced Tips on how to use IF formula in Excel that will SURPRISE you 😲

Excel's IF() is one of the most used and fundamental functions. In this video, learn how to use IF function and 5 advanced tips.

We are going to learn ✔ IF formula syntax ✔ Nested IF formulas ✔ IFS() function to replace nested if formulas ✔ AND conditions in IF formulas ✔ Choose function ✔ Index function ✔ Using IF with lookups

📑Video topics⏱
===============
0:00 - IF formula syntax and simple example
1:05 - Calculating GRADE using nested IF function
2:40 - Using IFS() function
3:46 - Checking for two or more conditions
4:45 - CHOOSE function
6:34 - BONUS trick - Using INDEX instead of CHOOSE
7:39 - Using IF with Lookups to switch between two tables
9:02 - Learning more about IF function

📗 Download Sample File & Practice 👇
===============================

📺 WATCH NEXT😎
=================

If you want to learn more about Excel functions, do check out below useful videos.

Learn EXCEL step by step 💻
=======================

If you want to learn all the essential bits of Excel in one handy place, please consider my Excel School program. This top-rated Excel course has been the secret of more than 20,000 people all over the world for their professional success.

~

Have a beautiful day 🌼🌞😀

#if #excel

[Seftehandle]

Perfect length and perfect tips. Exactly as per my taste. I dont use if alot since xlookup, however learnt a lot rearding choose and weekday! Thanks

[lealeveriza]

👏👏👏 I'm so happy I found your channel! You're a good teacher.👍

[salehmuhammad]

👍 great Chandoo. Knowing function is not important but knowing where to use is important and you taught us the second way. Thanks again big brother.

[AmanaButt]

very well explained with good examples. Worth watching. Thanks

[PrashantKg]

There is always something new to learn here. I didn't know that there is something called 'Ifs' function and I always used the nested if. Now I can use this new formula

[arunkumar-ueil]

As always you are awesome & make concepts simplified, Thank you!

[dennisvilcatomalopez]

Gracias por compartir los tips. Eres un grande 💯

[shiffamohammed]

Thanks a lot Chandoo for sharing such an amazing video. Another versatile use of if function!

[yemiakinwande]

very helpful video - ifs and choose is new and useful for me. many thanks

[JackKing.]

Excellent....good to see your pivot table advice.

[jaythakkar]

Awesome information and tips. Thank you

[peterjones]

Never realised about the black end bracket! Thank you!!

[vijayarjunwadkar]

Great video Chandoo! I learnt a few new tricks to use with IF and thanks a lot for that! 😊👍

[shriidharkulkarni]

You are really awesome teacher of Excel.

[nasirmuhammad]

Your method of teaching is simpler. Well Done!

[wrognOne]

Hey Chanddoo. you dont figure in those lists ....but you are a Super Hero of Excel. When they build that wall of fame youll be there

[surajbhardwaj]

IFS & two Xlookup function liked most... 👌, Great work sir, , ... Both function will help me sort out daily work in office....🙏🙏

[MAH]

Hi Chandoo,

I enhance my knowledge.

"THANK YOU"

Regards

[Munichandra_Reddy]

Hi Chandoo,

You have explained inside x lookup how to use two Datasets, it is amazing thing🙏🙏
I want to Your help, in my current role, I am facing lack of store produce issue, please tell me, where will I learn more Advanced Store produce ? Swift response

[mahmoudmohsen]

cool that index/choose tip and the xlookup thanks alot