IF and Logical Tests1/6
Spreadsheet practice
Complete each goal to unlock the next task.
Module progress0/6
Goal
Classify Drama as Good or Review.
IF returns one result when a condition is true and another when it is false.
Steps
- 1Use the Drama sold value as the condition.
- 2Return Good if the target is met and Review if it is not.
- 3Type = to start a formula.
- 4Use IF for this task.
- 5Use the worksheet labels to identify the correct range, criteria, lookup table, or return column.
- 6Press Enter and check the result.
0 points
Spreadsheet workspace
Loading spreadsheet engine...