Excel Study · Module 3: Decisions with IF
Class 24AND & OR inside IF
Intermediate1:36 videoFree
AND is true only when every rule is true; OR is true when any one rule is true. Put them inside IF to decide with two rules at once: a course takes people aged 18 or more AND scoring 60 or more — with OR, at least one rule is enough.
Try this AI prompt
Works in ChatGPT, Gemini, Copilot or Claude.
In Excel, B3 has a person's age and C3 their test score. Write a formula for D7 that shows Yes if the age is 18 or more and the score is 60 or more, otherwise No.
The answer that works
✓ checked in Excel=IF(AND(B3>=18, C3>=60), "Yes", "No")
AI can get Excel wrong. Paste its answer into Excel and test it before you trust it.