Excel Formula Repair: Fictional Stock Tracker

A small fictional stock tracker demonstrates three targeted formula repairs. The original total omitted the final stock row, an IFERROR formula made zero and missing usage look like zero days of cover, and a failed product lookup returned a blank.

The revised workbook includes all supplied stock rows, shows missing or zero usage explicitly, and distinguishes missing identifiers from unknown ones. Original inputs and the reference catalogue remain unchanged across the Before and After tabs. One additional input row is reserved and tested; further expansion requires extending the formulas.

Seventeen checks cover normal values, zero stock, zero usage, blank inputs, unknown and missing identifiers, changed stock, and the reserved new row. Temporary test inputs were restored before delivery.

This AI-assisted demonstration uses fictional, nonfinancial data. Formula outputs were checked in the generation engine and in the saved workbook caches. Native Microsoft Excel was not tested. It is not a client project or evidence of business results.