Combining clauses in Google Sheets - Step-by-Step Guide

Introduction

Combining clauses lets you join two or more conditions in a formula. This helps you check multiple things at once, like if a number is bigger than 10 and smaller than 20. It makes your formulas smarter and more useful.

When you want to check if a student's score is between 50 and 80 to give a pass grade.

When you need to find sales that happened in January and are above $1000.

When you want to filter a list to show only items that are in stock and cost less than $20.

When you want to highlight dates that are weekends or holidays.

When you want to count how many employees work in a department and have more than 5 years of experience.

Steps

Step 1: Click

- a blank cell where you want the result

The cell is selected and ready for typing

Step 2: Type

- the formula bar

The formula starts appearing in the cell

💡 Start with =AND( or =OR( depending on if you want all conditions true or any condition true)

Step 3: Type

- inside the parentheses of the formula

You add your first condition, for example A1>10

💡 Use cell references and comparison operators like >, <, =

Step 4: Type

- after the first condition

Add a comma and then the second condition, for example B1<20

💡 Add as many conditions as you need, separated by commas

Step 5: Type

- end of the formula

Close the parentheses and press Enter

💡 The cell will show TRUE if conditions are met, FALSE if not

Before vs After

Before

Cell C1 is empty, no formula

After

Cell C1 shows TRUE if A1 is greater than 10 and B1 is less than 20, otherwise FALSE

Settings Reference

AND function

📍 Formula bar when typing formulas

Returns TRUE only if all conditions inside are TRUE

Default: No default, you must enter conditions

OR function

📍 Formula bar when typing formulas

Returns TRUE if any one of the conditions inside is TRUE

Default: No default, you must enter conditions

Common Mistakes

Forgetting to separate conditions with commas inside AND or OR

The formula will show an error because it expects commas between conditions

Always put a comma between each condition inside the parentheses

Using AND when you want any condition to be true

AND requires all conditions to be true, so it may return FALSE unexpectedly

Use OR if you want the formula to return TRUE when any condition is true

Summary

Combining clauses lets you check multiple conditions in one formula using AND or OR.

AND returns TRUE only if all conditions are true; OR returns TRUE if any condition is true.

Remember to separate conditions with commas and close parentheses to avoid errors.