IF And OR Google Sheets

Steps to use IF with AND and OR in Google Sheets

• Step 1: Select a cell where you want the result to appear.

• Step 2: Type the formula starting with =IF(.

• Step 3: Inside the IF, use AND() to group multiple conditions.

• Step 4: Inside the AND, use OR() to check for multiple possible values.
  Example:
  =IF(AND(OR(B5="cs", B5="physics", B5="engg", B5="math"), D5="AI"), "yes", "no")

• Step 5: Add the second condition after the OR()—for example, D5="AI".

• Step 6: Close all parentheses properly, then press Enter to complete the formula.

Result: The formula will return "yes" if all conditions are met, or "no" if they are not.

Tip: Nesting AND and OR inside IF lets you build powerful logic for dynamic results.