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

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 – 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

Close Menu