Excel How-To

How to use AND and OR in Excel

The AND and OR functions allow you to evaluate multiple conditions simultaneously. Use them within an IF statement to create powerful, dynamic logic for your data analysis.

Do it with AI instead

Step by step

1
Select the target cell
Click on the cell where you want to display the result of your logical test.
2
Enter the IF function with AND/OR
Type =IF(AND(condition1, condition2), 'True', 'False') or =IF(OR(condition1, condition2), 'True', 'False') into the formula bar.
3
Define your logical conditions
Replace the placeholders with your specific cell references and criteria, such as A1>10.
4
Press Enter to apply
Press the Enter key to execute the formula and see the result.

=IF(AND(A2>50, B2<100), "Pass", "Fail")

Tips

AND returns TRUE only if all conditions are met, while OR returns TRUE if at least one condition is met.

FAQ

Can I combine AND and OR in the same formula?

Yes, you can nest them, for example: =IF(OR(AND(A1>10, B1>10), C1=0), 'Yes', 'No').