Combining clauses in Google Sheets - Cheat Sheet & Quick Revision

Recall & Review

beginner

What does it mean to combine clauses in Google Sheets formulas?

Combining clauses means joining multiple conditions or tests in one formula to get a result based on all those conditions together.

beginner

Which function in Google Sheets helps combine multiple conditions with AND logic?

The AND() function checks if all conditions are TRUE. It returns TRUE only if every condition inside it is TRUE.

beginner

How does the OR() function work when combining clauses?

OR() returns TRUE if at least one condition inside it is TRUE. It helps when you want to check if any one of many conditions is met.

beginner

Example: What does this formula do? =IF(AND(A1>10, B1<5), "Yes", "No")

It checks if A1 is greater than 10 AND B1 is less than 5. If both are true, it shows "Yes"; otherwise, it shows "No".

intermediate

Can you combine AND() and OR() in one formula? Give a simple example.

Yes! For example: =IF(AND(A1>5, OR(B1=10, C1=20)), "Pass", "Fail") checks if A1 is over 5 AND either B1 equals 10 OR C1 equals 20.

What does the AND() function return if one condition is FALSE?

A TRUE

B FALSE

C An error

D Depends on other conditions

AND() returns FALSE if any condition inside it is FALSE.

Which function returns TRUE if at least one condition is TRUE?

A OR()

B NOT()

C AND()

D IF()

OR() returns TRUE if any condition inside it is TRUE.

What will this formula return if A1=8 and B1=3? =IF(AND(A1>5, B1>5), "Yes", "No")

A "No"

B "Yes"

C An error

D Blank

B1>5 is FALSE, so AND() is FALSE, formula returns "No".

How do you combine conditions to check if A1 is greater than 10 OR B1 is less than 5?

A AND(A1>10, B1<5)

B NOT(A1>10, B1<5)

C OR(A1>10, B1<5)

D IF(A1>10, B1<5)

OR() checks if either condition is true.

Which formula checks if A1 is over 5 AND either B1 equals 10 OR C1 equals 20?

A IF(AND(A1>5, B1=10, C1=20), "Pass", "Fail")

B IF(OR(A1>5, AND(B1=10, C1=20)), "Pass", "Fail")

C IF(OR(A1>5, B1=10, C1=20), "Pass", "Fail")

D IF(AND(A1>5, OR(B1=10, C1=20)), "Pass", "Fail")

This formula uses AND and OR combined correctly.

Explain how to use AND() and OR() together in a Google Sheets formula to combine multiple conditions.

Think about checking if all conditions are true AND if at least one condition is true inside.

Describe a real-life situation where combining clauses with AND and OR in a spreadsheet formula would be helpful.

Consider decisions like eligibility, discounts, or filtering data.