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

For more advanced tips on IF, see this video – https://youtu.be/-yFpzIRifK4

📑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 👇
===============================

Visit https://chandoo.org/wp/wp-content/uploads/2022/06/if-examples.xlsx to download the example file for this video.

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

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

1) IF formula with 10 advanced tips – https://youtu.be/-yFpzIRifK4
2) SUMIFS formula with 10 advanced tips – https://youtu.be/YEt-aYbDTrs
3) Top 10 Excel functions for Data analysts – https://youtu.be/Q-XGJbHG8Vo
4) 15 Essential formulas for everyone using Excel – https://youtu.be/B5hayFelHDU

🤩 Excel formulas for Data Analysis – PLAYLIST – https://www.youtube.com/watch?v=-yFpzIRifK4&list=PLmejDGrsgFyDbGPi_5idB0RSWgTX3HPtM

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.

Visit https://chandoo.org/wp/excel-school-program/ for enrolment.

~

Have a beautiful day 🌼🌞😀

#if #excel