OR function in Excel - Practice Problems & Coding Challenges

Challenge - 5 Problems

📊 Formula Result

intermediate

Output of OR with multiple conditions

What is the result of the formula =OR(A1>10, B1<5, C1=7) if the cell values are A1=8, B1=3, and C1=9?

A TRUE

B FALSE

C 8

D 3

💡 Hint

Remember OR returns TRUE if any condition is TRUE.

A1>10 is FALSE, B1<5 is TRUE, C1=7 is FALSE. OR returns TRUE if any condition is TRUE.

❓ Function Choice

intermediate

Choosing the correct OR formula

Which formula correctly checks if either cell A2 is empty or cell B2 is greater than 100?

A =OR(ISBLANK(A2), B2&gt;=100)

B =OR(A2="", B2&gt;100)

C =OR(ISBLANK(A2), B2&gt;100)

D =OR(A2="", B2&gt;=100)

💡 Hint

ISBLANK checks if a cell is empty.

Option C uses ISBLANK to check if A2 is empty and B2>100 correctly. Other options either check >=100 or use text comparison which may not be reliable.

📊 Formula Result

advanced

Result of OR with nested AND conditions

What is the result of =OR(AND(A1>5, B1<10), AND(C1=3, D1>0)) if A1=6, B1=12, C1=3, and D1=1?

A 6

B FALSE

C 12

D TRUE

💡 Hint

AND returns TRUE only if all conditions inside it are TRUE.

AND(A1>5, B1<10) is FALSE because B1=12 is not less than 10. AND(C1=3, D1>0) is TRUE because both are true. OR returns TRUE if any argument is TRUE.

🎯 Scenario

advanced

Using OR to highlight overdue or high priority tasks

You want to highlight tasks in a spreadsheet if the due date is before today or the priority is 'High'. Which conditional formatting formula should you use?

A =OR(A2&gt;TODAY(), B2="High")

B =OR(A2&lt;TODAY(), B2="High")

C =AND(A2&lt;TODAY(), B2="High")

D =AND(A2&gt;TODAY(), B2="High")

💡 Hint

OR highlights if either condition is true.

Option B correctly uses OR to check if due date is before today or priority is High. Other options use AND or wrong date comparisons.

❓ data_analysis

expert

Counting rows where OR condition is met

You have a table with columns Score1 and Score2. Which formula counts how many rows have Score1>80 or Score2>80?

A =SUMPRODUCT(--( (Score1&gt;80) + (Score2&gt;80) &gt; 0 ))

B =COUNTIFS(Score1, ">80") + COUNTIFS(Score2, ">80")

C =SUM(IF(OR(Score1&gt;80, Score2&gt;80),1,0))

D =COUNTIF(Score1&gt;80, TRUE) + COUNTIF(Score2&gt;80, TRUE)

💡 Hint

SUMPRODUCT can handle OR logic by adding boolean arrays.

Option A correctly counts rows where either Score1 or Score2 is greater than 80 by adding boolean arrays and checking if sum is greater than zero. Options A and D double count rows where both conditions are true. Option A is invalid syntax.