This IF, AND and OR guide is not published yet
For now, the closest page to look at is a community question on Microsoft's Q&A site about using AND and OR in Excel. It is a user forum thread, not official Microsoft documentation, so check any formula from it on a copy of your sheet before relying on it.
Why there are no formulas on this page yet
A formula guide is only useful if every argument and example in it is right. Nothing here has yet been checked against Microsoft's own documentation, so this page leaves the formulas out rather than guess. A wrong formula in a spreadsheet can quietly return the wrong answer for months, which is worse than no formula at all.
Other community pages on the same question
If you need an answer before the full guide is ready, these pages discuss related problems. None of them is official Microsoft documentation:
- A Microsoft Q&A thread about using IFS and AND together, which is useful if you are choosing between nested IF and IFS.
- A Microsoft Q&A thread about conditional formatting with AND and OR, for when you want to colour cells rather than return a value.
- Trump Excel's page on the IF and AND functions, a third-party blog.
Forum answers are written by other users and can be wrong or specific to one version of Excel.
How to test a formula you find elsewhere
Before you paste a formula from any of these pages into a real workbook, make a copy of the file and try it there first. Add a few test rows where you already know the right answer: one that should pass every condition, one that should fail every condition, and one that should pass only some. If the formula gets all three right, it is much more likely to be safe on your real data. Also try a row with a blank cell, because blanks often behave differently from what you expect.
