Free IF Practice for Google Sheets

Question 1 of 3

Try it yourself

In H2, write an IF that returns "Bonus" when the Revenue in F2 is over 400, and "No Bonus" when it is not.

A

B

C

D

E

F

G

H

I

J

K

L

1

2

3

4

5

6

Date

Salesperson

Region

Product

Units

Revenue

Commission

Bonus?

1/5/2026

Sherlock Holmes

Baker Street

Listening Device

12

$239.88

$24.00

Question 2 of 3

Try it yourself

In I4, band the Revenue in F2 with a nested IF: 500 or more is High, 300 or more is Medium, anything else is Low.

A

B

C

D

E

F

G

H

I

J

K

L

M

1

2

3

4

5

6

Date

Salesperson

Region

Product

Units

Revenue

Commission

Bonus?

1/8/2026

Inspector Lestrade

Baker Street

Pocket Watch

15

$525.00

$52.50

Answer

Question 3 of 3

Try it yourself

In I4, return "Priority" when row 5 is BOTH Baker Street AND over 300 in Revenue, otherwise "Standard". Both tests go inside AND().

A

B

C

D

E

F

G

H

I

J

K

L

M

1

2

3

4

5

6

Date

Salesperson

Region

Product

Units

Revenue

Commission

Bonus?

1/8/2026

Inspector Lestrade

Baker Street

Pocket Watch

15

$525.00

$52.50

Answer

You just read about IF. Now type one.