How to hide certain symbols

I use an excel spreadsheet alot for billing in the construction industry. There are premade formulas in this spreadsheet. When no input value is present, the total column(s) either show a "$0.00" or show "#DIV/0!". How do I hide these results for the rows that do not yet have any input? I have seen it done on other speadsheets, i just cant figure out how to do it.

See attached example.