IF AND Generator
Return one value only when every condition is true, using IF with a nested AND.
IF AND
Return one value only when every condition is true, using IF with a nested AND.
A comparison that returns TRUE or FALSE, for example B2>=100.
The second test. Text you compare against needs quotes, for example C2="Paid".
Returned only when every condition is true. Text needs quotes.
Returned when at least one condition is false. Text needs quotes.
=IF(AND(B2>=100, C2="Paid"), "Approved", "Review")Worked Example
Flag an order as ready to ship only when the amount is at least 100 and the invoice status is Paid.
=IF(AND(B2>=100, C2="Paid"), "Approved", "Review")Returns: Returns "Approved" when B2 is 100 or more AND C2 reads Paid; returns "Review" if either test fails.
Checks Before You Paste
- •AND is a function, not an operator: the SQL-style B2>=100 AND C2="Paid" is not valid spreadsheet syntax, and neither is &&. Every test has to sit inside AND(...) separated by commas.
- •Never chain comparisons like 10<A2<20. Excel and Google Sheets evaluate that left to right, so 10<A2 collapses to TRUE or FALSE and then gets compared against 20 - which is not the range test you meant. Write AND(A2>10, A2<20) instead.
- •Text comparisons are case-insensitive, so C2="paid" also matches "Paid", and a blank cell satisfies both C2="" and C2=0. Use EXACT(C2,"Paid") for case-sensitive checks and add C2<>"" when blanks must not count.