IF: choose between two results
Exercise 1 of 4
A pass needs 50 or more. In C2, check whether Ana passed. A comparison gives TRUE or FALSE.
About this lesson
IF checks a test and returns one result when it's true and another when it's false. It starts with comparisons like >=, which give TRUE or FALSE.
In this lesson
- A pass needs 50 or more. In
C2, check whether Ana passed. A comparison gives TRUE or FALSE. - In
C2, show "Pass" if Ana scored 50 or more, otherwise "Fail". - Now do the same for Ben in
C3. - Sellers with sales of 1,000 or more get a 5% bonus, the others get 0. In
C2, work out Ana's bonus.
Use the arrow keys to move between cells; each cell is read out as you go. Type a formula and press Enter. The sheet is also available as a table below.
fx
Type in C2 and press Enter to check.