The IF function in Excel is like asking a question. If the answer is true, Excel gives you one thing. If the answer is false, it gives you something else. But what if you want to check more than one condition? Don’t worry—it’s easy! if function excel - multiple conditions

What is the IF Function?

The IF function checks something and gives a result based on it.

Example:

=IF(A1>10, "Yes", "No")

This means:

If the number in A1 is greater than 10, show “Yes”. If not, show “No”.



What if You Have More than One Condition?

You can check multiple conditions by using:

1. AND Function with IF

This checks if all conditions are true.

Example:

=IF(AND(A1>10, B1<5), "OK", "Not OK")

This means:

If A1 is greater than 10 and B1 is less than 5, show &ldquo;OK&rdquo;. Otherwise, show &ldquo;Not OK&rdquo;.

2. OR Function with IF

This checks if any one condition is true.

Example:

=IF(OR(A1>10, B1<5), "Pass", "Fail")

This means:

If A1 is greater than 10 or B1 is less than 5, show &ldquo;Pass&rdquo;. Otherwise, show &ldquo;Fail&rdquo;.

What is Nested IF?

Sometimes you want to check more than two things. You can nest IF functions inside each other.

Example:

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

This gives:

&ldquo;A&rdquo; if A1 > 90

&ldquo;B&rdquo; if A1 > 80

&ldquo;C&rdquo; if A1 > 70

&ldquo;Fail&rdquo; if none are true

Tips for Using IF with Multiple Conditions

Use AND if all things must be true

Use OR if only one thing must be true

Use nested IFs for many choices

Always close your brackets ) at the end!

Final Words

The IF function in Excel helps you make smart choices based on data. When you add AND, OR, or nested IFs, you can check many conditions at once. It may look tricky at first, but with practice, it becomes easy!



Let Excel do the thinking for you!