Chapter 3 Making decisions ・ MISSION 12
Mission 12: Grade scores A, B or C
Task
In C2, show “A” for 90 or more, “B” for 70 or more, and “C” otherwise.
C2fx
A
B
C
1
Name
Score
Grade
2
Liam
58
3
Emma
82
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 ・ MISSION 12
Grade scores A, B or C
In C2, show “A” for 90 or more, “B” for 70 or more, and “C” otherwise.
A
B
C
1
Name
Score
Grade
2
Liam
58
3
Emma
82
4
Olivia
93
5
Noah
67
6
Ava
75
7
A
B
C
1
Name
Score
Grade
2
Liam
58
C
3
Emma
82
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: =IFS(B2>=90,"A",B2>=70,"B",TRUE,"C")
IFS checks from the top and returns the first matching result. If nothing matches, it returns #N/A, so put TRUE last.
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).