The IF function

IntermediateBeginner

14 questions, about 20 minutes

Let Excel choose between two outcomes.

What we'll do

  • The three parts of IF
  • Returning text
  • Returning a calculation

What you'll use

  • IF

How it works

In an example you watch and don't need to fill anything in. You answer a question yourself. If it goes wrong, you get a tip, then a hint and finally the solution.

2examplesYou watch
14questionsYou do it yourself
Full explanation