Microsoft Excel is a powerful tool that helps us work with numbers and data. One of its best features is the IF function. It lets us ask questions like: “If this is true, what should happen?” But sometimes, we need to check more than one condition. That’s where multiple IF conditions come in. excel if multiple conditions

What Is the IF Function?

The basic IF function looks like this:

sql

Copy

Edit

=IF(condition, value_if_true, value_if_false)

For example:

arduino

Copy

Edit

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

This means: “If the number in cell A1 is greater than 10, then show 'Yes', otherwise show 'No'.”

How to Use IF with AND

Sometimes you want two or more things to be true. Use the AND function inside IF.

Example:

arduino

Copy

Edit

=IF(AND(A1>10, B1="Yes"), "Pass", "Fail")

This means: “If A1 is more than 10 and B1 says 'Yes', then show 'Pass'. Otherwise, show 'Fail'.”

How to Use IF with OR

What if you want only one of the conditions to be true? Then use OR.

Example:

arduino

Copy

Edit

=IF(OR(A1>10, B1="Yes"), "Okay", "Not Okay")

This means: “If A1 is more than 10 or B1 says 'Yes', then show 'Okay'. Otherwise, show 'Not Okay'.”

Nested IF (IF Inside Another IF)

Sometimes you need to test many conditions. You can nest IF functions.

Example:

arduino

Copy

Edit

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

This means:

If A1 is more than 90, give "A"

If more than 80, give "B"

If more than 70, give "C"

Otherwise, give "Fail"

Final Words

Using IF with multiple conditions in Excel helps you make smart decisions based on your data. Whether you use AND, OR, or nested IFs, you can control what happens depending on the values in your cells. Keep practicing, and soon, you’ll be making your Excel sheets work smarter for you!