Sheets ExercisesFree · Lesson 8: AND and OR
0 pts
✕
0
Step 1 of 4

Require both tests

In E2, return Ready only when B2 is at least 20 and C2 is Yes. Otherwise, return Hold.

Show formula shape
=IF(AND(first test, second test), "Ready", "Hold")
100%
E2fx
A
B
C
D
E
F
G
1
Staff
Hours
Trained
Remote
Assignment
2
Ana
32
Yes
No
3
Bo
18
Yes
Yes
4
Cam
28
No
Yes
5
Dee
12
No
No
6
7
8
9
10
Team schedule
E2