Why logical functions handle conditions in Google Sheets - Challenge Your Understanding

Challenge - 5 Problems

📊 Formula Result

intermediate

What is the output of this IF formula?

Given the formula =IF(A1>10, "High", "Low") and cell A1 contains 8, what will be the result?

Google Sheets

=IF(A1>10, "High", "Low")

A TRUE

B "High"

C "Low"

D FALSE

💡 Hint

Think about whether 8 is greater than 10.

The IF function checks if the condition A1>10 is true. Since 8 is not greater than 10, the condition is false, so the formula returns the value for false, which is "Low".

❓ Function Choice

intermediate

Which function correctly checks if both conditions are true?

You want to check if cell A1 is greater than 5 and cell B1 is less than 10. Which formula correctly does this?

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

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

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

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

💡 Hint

AND returns TRUE only if all conditions are true.

The AND function returns TRUE only if all conditions inside it are true. Here, it checks if A1 is greater than 5 and B1 is less than 10.

❓ data_analysis

advanced

Analyze the output of nested logical functions

What is the result of this formula if A1=7 and B1=12?
=IF(AND(A1>5, B1<10), "Yes", "No")

Google Sheets

=IF(AND(A1>5, B1<10), "Yes", "No")

A "No"

B FALSE

C TRUE

D "Yes"

💡 Hint

Check each condition inside AND separately.

The AND function checks if both A1>5 and B1<10 are true. A1=7 is greater than 5 (true), but B1=12 is not less than 10 (false). Since both are not true, AND returns FALSE, so IF returns "No".

🎯 Scenario

advanced

Choose the correct formula to handle multiple conditions

You want to assign grades based on score in cell A1:
- Above 90: "A"
- 80 to 90: "B"
- 70 to 79: "C"
- Below 70: "F"
Which formula correctly assigns the grade?

A =IF(A1>90, "A", IF(A1>=80, "B", IF(A1>=70, "C", "F")))

B =IF(A1>90, "A", IF(A1>80, "B", IF(A1>70, "C", "F")))

C =IF(A1>=90, "A", IF(A1>=80, "B", IF(A1>=70, "C", "F")))

D =IF(A1>90, "A", IF(A1>80, "B", IF(A1>=70, "C", "F")))

💡 Hint

Check the boundary conditions carefully.

Option A correctly uses >90 for "A", then >=80 for "B", >=70 for "C", and else "F". This covers all ranges without overlap or gaps.

🧠 Conceptual

expert

What error occurs with this logical formula?

What error will this formula produce?
=IF(AND(A1>5, B1), "Yes", "No")
Assume B1 contains text "Hello".

Google Sheets

=IF(AND(A1>5, B1), "Yes", "No")

A #REF! error

B "Yes"

C "No"

D #VALUE! error

💡 Hint

AND expects logical values, what happens with text?

The AND function expects logical TRUE or FALSE values. Since B1 contains text "Hello", it causes a #VALUE! error because text is not a valid logical value.