Conditional Logic

Excel formula for IF with AND / OR conditions

Return a value only when several conditions are all (or any) true.

Copy this formula

=IF(AND(A2>0, B2="Yes"), "OK", "No")

How the formula works

AND is TRUE only when every condition is met; OR is TRUE when at least one is. Nest them inside IF to make decisions on multiple columns at once.

=IF(OR(A2>100, B2="VIP"), "Priority", "Normal")→Priority

Flags rows that are large OR VIP.

Can I mix AND and OR?

Yes — nest them: =IF(AND(A2>0, OR(B2="X", B2="Y")), "Yes", "No").

Need a formula for your own data?

Describe what you want in plain language and let ExcelGPT write, explain, and verify the formula — free to start, no plugin.