AND and OR functions in Google Sheets - Cheat Sheet & Quick Revision

Recall & Review

beginner

What does the AND function do in Google Sheets?

The AND function checks if all given conditions are TRUE. It returns TRUE only if every condition is TRUE; otherwise, it returns FALSE.

beginner

What is the result of OR(TRUE, FALSE, FALSE) in Google Sheets?

The OR function returns TRUE if at least one condition is TRUE. Since one condition is TRUE here, the result is TRUE.

beginner

Write a formula using AND to check if A1 is greater than 10 and B1 is less than 5.

The formula is =AND(A1>10, B1<5). It returns TRUE only if both conditions are true.

beginner

How does the OR function behave if all conditions are FALSE?

If all conditions are FALSE, the OR function returns FALSE because it needs at least one TRUE to return TRUE.

intermediate

Can AND and OR functions be combined in one formula? Give a simple example.

Yes! For example, =AND(A1>5, OR(B1=10, C1=20)) checks if A1 is greater than 5 AND either B1 equals 10 OR C1 equals 20.

What does =AND(TRUE, FALSE, TRUE) return?

A TRUE

B FALSE

C Error

D 0

AND returns TRUE only if all inputs are TRUE. Here, one is FALSE, so the result is FALSE.

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

A =OR(A1>5, B1<10)

B =AND(A1>5, B1<10)

C =NOT(A1>5)

D =SUM(A1, B1)

OR returns TRUE if any condition is TRUE.

What will =OR(FALSE, FALSE, FALSE) return?

A TRUE

B 0

C FALSE

D Error

OR returns FALSE if all conditions are FALSE.

How do you check if both A1 and B1 are greater than 0?

A =SUM(A1>0, B1>0)

B =OR(A1>0, B1>0)

C =NOT(A1>0)

D =AND(A1>0, B1>0)

AND checks if all conditions are TRUE.

Which formula checks if A1 is greater than 10 OR B1 is less than 5?

A =OR(A1>10, B1<5)

B =AND(A1>10, NOT(B1<5))

C =AND(A1>10, B1<5)

D =OR(A1<10, B1>5)

OR returns TRUE if either condition is TRUE.

Explain how the AND function works and give a real-life example where you might use it in a spreadsheet.

Think about situations where everything must be true to succeed.

Describe the difference between AND and OR functions and when you would use each.

Consider the difference between 'all must be true' and 'any can be true'.