Sheets ExercisesFree · Lesson 6: IF basics
0 pts
✕
0
Step 1 of 4

Test a number

In C2, return Review when the total in B2 is at least 100. Otherwise, return Standard.

Show formula shape
=IF(test, result if true, result if false)
100%
C2fx
A
B
C
D
E
F
1
Order
Total
Review
2
O-104
145
3
O-105
72
4
O-106
100
5
O-107
38
6
7
8
9
10
Orders
C2