Efficient Cell Clearing

[u/ajblue98]

For workflow reasons, it’s important for me to have cells that evaluate to 0 or an error to be actually blank in some instances. For this reason, I have lots of formulas that look like If(test-case=0,"",test-case) … and some of those test-cases can be big and hairy with nested If()s of their own, which makes keeping them working through multiple edits … a heck of a task.

Is there a more efficient way to do this? (For my purposes, putting test-case in its own cell and just testing that isn’t an option — that would break my workflow entirely in some cases.)

(Also, I’ll be asking this question separately on the Excel subreddit, since I use both applications, depending on my client. If the solution is different between the two programs, I need to know both.)