This question is a perfect snapshot of the friction that lives inside every spreadsheet user's daily life. The user's checkbook balance hits zero, and Excel punishes that neutral number with red ink and parentheses, as if being broke weren't obvious enough. The formula works. The math is correct. But the formatting treats zero like a mistake. For anyone who has ever stared at a cell wondering why the software insists on making a simple truth look dramatic, this is the moment where the tool stops helping and starts getting in the way.
The real problem here isn't the formula. It's that Excel's default formatting rules treat negative numbers and zeros as the same visual category. The red font and parentheses are designed for debt, not for emptiness. But a zero balance is not a negative balance. It is a precise, intentional result. The user already found a workaround, using LOOKUP to pull the last value, but that solution bypasses the sum entirely, which defeats the purpose of tracking a running total. The spreadsheet should honor the user's logic, not force them to choose between correct math and correct display.
The fix is straightforward once you know where to look, and that's the deeper point. Custom number formatting lets you write three separate rules in one string, separated by semicolons: one for positive numbers, one for negative numbers, and one for zeros. A format like `$#,##0.00;($#,##0.00);$0.00` tells Excel to treat zero as its own category, leaving it black and unparenthesized. No conditional formatting. No workaround formulas. Just a single change that restores sanity. The user doesn't need a better spreadsheet; they need a spreadsheet that respects their intent.
This is what happens when software assumes it knows better than the person using it. The red zero is a small annoyance, but it represents a larger pattern: tools that prioritize their own conventions over the user's reality. The good news is that the fix already exists inside the tool. The better news is that the next generation of spreadsheet tools, built with AI-native logic, will learn to ask what you mean instead of guessing. Until then, a custom number format is all it takes to stop your checkbook from yelling at you for being at zero.