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
Watch video 5 Advanced Tips on how to use IF formula in Excel that will SURPRISE you 😲 online without registration, duration hours minute second in high quality. This video was added by user Chandoo 28 June 2022, don't forget to share it with your friends and acquaintances, it has been viewed on our site 176,873 once and liked it 4.8 thousand people.