Zeros showing up in my cells

Hey guys,

I am trying to create some kind of smart time sheet setup that will help me sorting out certain tasks automatically. So far so good, but of course Excel is being a pain again and I ended up having some formatting problems I can't seem to solve.

It's a bit complicated to explain, but I'll try anyway:

I have two sheets with tasks and hours. The first one has a list of tasks, categories and hours. The second sheet is supposed to be a printable version of the first sheet with certain tasks filtered out.
So basically both sheets look identically, just the has a formula that does not show any hours when they fall in a certain category.
The formula I used is:

Please Login or Register  to view this content.

That kind of works and does not show the hours when the category on the first worksheet is set to "Unapproved Task". My problem however is that whenever the cell on the first worksheet has no hours set, and is simply empty, instead of having any hour number in there it will show me a '0' (zero) instead of just an empty string in the corresponding cell on the second worksheet.
To sum it up:
For an approved task, it takes it over to the second worksheet, for an unapproved one it leaves the cell empty as desired, but whenever the source cell is empty, I end up seeing a 0 in the second sheet.

I hope that makes any sense and somebody can help me solve that. I know there is some option to hide 0s generally but sounds like a client setting and I don't want to use that, since the sheet is supposed to be used by different people on different machines.
Thanks!

Any cells left blank will be automatically filled in by excel as 0's

This is true when using linked data sheets. This is because Linking a blank cell to a separate sheet has a value of 0

Originally Posted by NBVC

=IF(EXACT(Actual_Hours!E20,"Unapproved Task"),"",IF(Actual_Hours!F20=0,"",Actual_Hours!F20))

Thank you so much. That fixed it perfectly.