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:


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

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!