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