Chapter 3 Making decisions ・ MISSION 10
Mission 10: Pass or fail
Task
In C2, show “Pass” if the score in B2 is 70 or more, and “Fail” if not.
C2fx
A
B
C
1
Name
Score
Result
2
Emma
82
3
Liam
58
4
Olivia
93
5
Noah
67
6
Ava
75
7
Select a range by dragging with the mouse or with the arrow keys while typing a formula. Type part of a function name and press Tab to complete it.
Chapter 3 startsMaking decisions
Chapter 3 ・ MISSION 10
Pass or fail
In C2, show “Pass” if the score in B2 is 70 or more, and “Fail” if not.
A
B
C
1
Name
Score
Result
2
Emma
82
3
Liam
58
4
Olivia
93
5
Noah
67
6
Ava
75
7
A
B
C
1
Name
Score
Result
2
Emma
82
Pass
3
Liam
58
4
Olivia
93
5
Noah
67
6
Ava
75
7
The tutorial is On. Change this in theMission list.
Functions used in this mission
Example formula: =IF(B2>=70,"Pass","Fail")
The IF condition is a comparison like B2>=70. “At least” is >=, “more than” is >. Put the text to return in quotes.
To practice one function at a time:Function drillExcel function list
* This is a simulation of Excel calculations and may differ in some ways from how Excel actually behaves.
* Some actions may not work depending on your browser environment (for example, shortcuts used by extensions).