Clear explanations and step-by-step fixes for Excel errors, formulas, Power Query and Pivot Tables — written for people who just want their spreadsheet working again.
| A | B | C | |
|---|---|---|---|
| 1 | Revenue | #REF! A cell the formula pointed to was deleted or moved. Fix: re-point the reference or use INDEX instead of a hard cell link. | 420 |
| 2 | #DIV/0! You're dividing by a blank or zero cell. Fix: wrap it in IFERROR or check the divisor with an IF first. | 12 | 0 |
| 3 | Total | 310 | #N/A A lookup found no match. Fix: check for extra spaces or mismatched formats in the lookup value. |
We've hit every one of these errors ourselves. Excel is powerful but unforgiving — cells shift, formulas break, and the error messages rarely explain themselves. We write down what actually fixed the problem, so you don't have to dig through a forum thread to find it.