Write an Excel IF formula with multiple conditions.

What this page gives you

• A draft Excel IF formula using nested IF, IFS, AND, OR, or NOT when those functions fit the rule.
• A plain-English read of which condition is tested first and what each branch returns.
• Checks for blanks, thresholds, mixed AND/OR logic, and rows where more than one condition could be true.

When to use it

Use this page when a spreadsheet rule has more than one condition, such as reviewing high-value invoices that are late or from new customers, or approving only rows that meet every required field. It works best when you can provide the relevant columns and at least one row for each expected result.

Do not keep adding nested IF branches if the rule is really a lookup table, scoring table, or long ordered list. In those cases, IFS, SWITCH, XLOOKUP, or a helper table can be easier to maintain.

Worked example

For invoice rows with amount in B, payment status in C, and customer type in D, flag a row as Review when the amount is over 5000 and either the invoice is past due or the customer is new.

=IF(AND(B2>5000,OR(C2="Past Due",D2="New")),"Review","OK")

The formula first checks whether the amount is above 5000, then requires either Past Due status or New customer type. Only rows that pass both parts return Review.