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
For more advanced tips on IF, see this video - • 10 Advanced IF formulas every analyst...
📑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/upl... 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 - • 10 Advanced IF formulas every analyst...
2) SUMIFS formula with 10 advanced tips - • 10 *next level* SUMIFS tricks only Ex...
3) Top 10 Excel functions for Data analysts - • Learn these top 10 Excel Formulas to ...
4) 15 Essential formulas for everyone using Excel - • These are the ONLY 15 functions you n...
🤩 Excel formulas for Data Analysis - PLAYLIST - • 10 Advanced IF formulas every analyst...
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-p... for enrolment.
~
Have a beautiful day 🌼🌞😀
#if #excel