Understanding IF Formula in Excel with Multiple Conditions-Forum-Culture Informatique

The IF formula in Excel helps you make decisions. It checks if something is true or false and then gives a result. But what if you want to check more than one condition? Don’t worry—Excel can do that too! if formula in excel with 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)
Example:

arduino
Copy
Edit
=IF(A1>10, « Yes », « No »)
This checks if the value in cell A1 is greater than 10. If yes, it shows « Yes ». If not, it shows « No ».

Using IF with AND (Multiple True Conditions)
If you want all conditions to be true, use AND.

Example:

arduino
Copy
Edit
=IF(AND(A1>10, B1<5), « Pass », « Fail »)
This formula checks if A1 is more than 10 and B1 is less than 5. If both are true, it returns « Pass ». Otherwise, it returns « Fail ».

Using IF with OR (One Condition Can Be True)
If any one condition is enough, use OR.

Example:

arduino
Copy
Edit
=IF(OR(A1>10, B1<5), « OK », « Not OK »)
Here, if either A1 is greater than 10 or B1 is less than 5, it will return « OK ».

Nesting IF Statements (More Than Two Options)
Sometimes you need more choices. You can put one IF inside another. This is called nesting.

Example:

arduino
Copy
Edit
=IF(A1>80, « A », IF(A1>60, « B », « C »))
This gives:

« A » if A1 is more than 80

« B » if A1 is more than 60

« C » if A1 is 60 or less

Final Words
The IF formula is powerful when used with AND, OR, and nested IFs. It helps you solve problems easily. Whether you’re checking marks, prices, or values, Excel makes it simple to decide what to do next. Try a few formulas, and you’ll become better in no time!