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 the IF function and five advanced tips, including IF formula syntax, nested IF formulas, the IFS() function to replace nested IFs, AND conditions in IF formulas, the CHOOSE function, the INDEX function, and using IF with lookups. 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