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, valueiftrue, valueiffalse) 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!