The IF formula in Excel helps you check if something is true or false. You can also use it to make decisions. But sometimes, you need to check more than one thing. That’s when you use multiple conditions in the IF formula. if formula excel multiple conditions

What is the IF Formula?

The basic IF formula looks like this:

sql

Copy

Edit

=IF(condition, value_if_true, value_if_false)

For example:

arduino

Copy

Edit

=IF(A1>50, "Pass", "Fail")

This means: if the value in cell A1 is more than 50, then write "Pass". If not, write "Fail".

Using AND with IF (All Conditions Must Be True)

You can use AND when you want all conditions to be true.

Example:

arduino

Copy

Edit

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

This checks if both A1 and B1 are greater than 50. If both are true, it shows "Pass". If even one is false, it shows "Fail".

Using OR with IF (Any One Condition Must Be True)

You can use OR when you want at least one condition to be true.

Example:

arduino

Copy

Edit

=IF(OR(A1>50, B1>50), "Pass", "Fail")

This means: if either A1 or B1 is more than 50, it shows "Pass". If both are 50 or less, it shows "Fail".

Nesting IFs (More Than Two Options)

Sometimes you want to check for more than two outcomes. You can use nested IF formulas.

Example:

arduino

Copy

Edit

=IF(A1>80, "Excellent", IF(A1>50, "Good", "Poor"))

This checks:

If A1 > 80 → "Excellent"

If A1 > 50 → "Good"

Otherwise → "Poor"

Final Words

The IF formula becomes powerful when you add AND, OR, or nested IFs. It helps you make smart decisions in Excel with just a few words. Try using it step by step, and you’ll get better with practice!

Let me know if you want real-life examples or a downloadable Excel sheet.