Jun 28, 2022 12:00 AM

5 Advanced Tips on how to use IF formula in Excel by Chandoo

External YouTube Channel

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