Zero Values returned in formulas

I have a database in which there are 2 sheets for different pay weeks. the sheets are a exact copy of each other with the same formats but one sheet displays a 0 when there is no data in and the other displays nothing. I want the cells to display nothing when there is no data. How do I achieve this.

I have attached the file