IFERROR
Catch errors before they spread.
Why planners need it
A single #DIV/0! or #N/A poisons every total downstream. IFERROR keeps dashboards clean and formulas honest.
Syntax
=IFERROR(formula, value_if_error)
Worked example
Occupancy when an interval had no staff would divide by zero:
=IFERROR(Workload/Agents, 0) → shows 0 instead of #DIV/0!, so the daily average still calculates.
Watch out: Don’t use it to hide real problems — a lookup returning the fallback may mean your key is wrong. Use it deliberately, not as a blanket wrapper.