kevin
regano8969@genebag.com
IF Formula in Excel with Multiple Conditions (Beginner's Guide) (36 อ่าน)
21 มิ.ย. 2568 15:41
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.
101.53.255.189
kevin
ผู้เยี่ยมชม
regano8969@genebag.com