Why OR function in Excel? - Purpose & Use Cases

The Big Idea

What if you could check many conditions with just one simple formula?

The Scenario

Imagine you have a list of students and you want to check if each student passed either Math or English. You try to look at each score one by one and write down if they passed at least one subject.

The Problem

Doing this by hand is slow and tiring. You might forget to check some scores or make mistakes when deciding if a student passed. It's hard to keep track when you have many students.

The Solution

The OR function lets you quickly check if any one of several conditions is true. Instead of checking each subject separately, you can write one formula that says "Did the student pass Math OR English?" and get the answer instantly.

Before vs After

✗ Before

If Math >= 50 then Pass else check English >= 50 then Pass else Fail

✓ After

=OR(Math>=50, English>=50)

What It Enables

With the OR function, you can easily test multiple conditions at once and get clear yes/no answers, saving time and avoiding mistakes.

Real Life Example

Teachers can quickly mark students who passed at least one subject without checking each score manually, making grading faster and more accurate.

Key Takeaways

Manual checking is slow and error-prone.

OR function tests multiple conditions in one step.

It helps make decisions quickly and correctly.