Recall common formula-reference smells and the matching audit response.
mixed-card-deck smell-to-move-map confidence-chips Smell A growing list has a summary formula with a fixed-looking boundary. What should you inspect? Trace the summary precedents and check the first row outside the old range. Silent omissions often happen when new rows land below a formula boundary. Weak vs strong How should you investigate a suspicious total? Formula errors can calculate cleanly, so the dependency path matters more than appearance. Objection The total ties, so the workbook must be fine. A teammate wants to skip the formula-range review. Your line A tied total is useful, but it does not prove the range includes…
Sign up free — one personalized lesson every day, matched to your role and goals.
Already have an account? Sign in