Sheets Exercises
Free ·
Lesson 7: Comparisons and IFS
0 pts
✕
0
Step 1 of 4
Compare with >=
In
D2
, return
Pass
when the score in
B2
is at least 70. Otherwise, return
Review
.
Show formula shape
=IF(
score
>=70, "Pass", "Review")
↶
↷
100%
$
%
.0
B
I
Data
D2
fx
A
B
C
D
E
F
1
Student
Score
Attendance
Result
2
Maya
70
Present
3
Noah
67
Present
4
Iris
84
Absent
5
Leo
73
Present
6
7
8
9
10
Class roster
D2
=
(
:
,
)
Check my answer