0 of 62
Basics·Lesson 16 of 62Free

How to use IF with AND in Google Sheets

Combine two conditions

How IF + AND works

AND is TRUE only when every condition inside it is true. Put it inside IF to test several things at once. OR is TRUE when any one is.

IF(AND(test1, test2), if true, if false)
Example on this data
=IF(AND(D2="Desk",F2>200),"Big desk","Other")→Big desk

Both the product and the price must match.

What you’ll do

You’ll flag an order as priority only when two things are both true. Checking more than one condition at once is how real rules work, like “West region and a decent size”.

Try it

Type =IF(AND(D2="Desk",F2>200),"Big desk","Other") into K2 and press Enter. Watch what the sheet does.

The result will appear in K2.

K2
ABCDEFGHIJK
1OrderRepRegionProductUnitsPriceOrder dateShip date
21001AnaWestDesk32401/5/20261/9/2026
31002BoEastChair8851/12/20261/20/2026
41003CyWestLamp12301/19/20261/22/2026
51004DiNorthDesk22402/2/20262/13/2026
61005AnaWestChair5852/9/20262/12/2026
71006EveSouthShelf41202/16/20262/27/2026
81007BoEastLamp20303/2/20263/4/2026
91008CyWestShelf11203/9/20263/18/2026
101009DiNorthChair6853/16/20263/19/2026
111010EveSouthDesk72403/23/20264/1/2026
Ctrl+/ shows the shortcuts

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

See Pro, $49.99 once