Basics·Lesson 15 of 62Free

How to use IF in Google Sheets

Make a decision

How IF works

IF checks a condition and returns one value when it's true and another when it's false.

IF(test, if true, if false)

Example on this data

=IF(F2>100,"Premium","Budget")→Premium

Labels the row 2 order by its price.

You’ll label one order as bulk or standard depending on its size. A formula that makes a decision lets a sheet sort things into groups for you.

Type =IF(F2>100,"Premium","Budget") into K2 and press Enter. Watch what the sheet does.

The result will appear in K2.

Ctrl+/ shows the shortcuts

Your turn

In K2, show "Bulk" if the order in row 2 has 10 or more units, otherwise "Standard".

Type in K2 and press Enter. While you type, click cells to add them.

Ctrl+/ shows the shortcuts

Your formula also runs on a hidden, shuffled copy of the data, so only real formulas pass.

The first 18 lessons are free. Pro unlocks the other 44, including a real-world scenario for every section and five closing projects.