I've been using =IF(formula=0,"",formula) to leave a cell blank if the
formula didn't come up with any value. However because this time around, I
also need to use the cells that have this formula as a reference cell, so I
can't leave it as "" in the middle of the formula. By doing that, there will
a #VALUE! error.

This lead me to the second try, which is instead of putting "", I make the
formula this way =IF(formula=0,,formula). This helps me eliminate the
#VALUE! error, but it doesn't leave the cell blank if the formula calculate
to zero value; it shows 0 instead of leaving the cell blank.

FYI, I'm working on a balance-sheet-like template that will bring the
balance line by line...

Does anyone know how to work this thing around?

Thank you so much,
Neon