This depends on what you REALLY want. Some close reading shows a contradiction, you know. I'll explain it later. It might well be that - in the context of your application - the contradiction doesn't arise, but you don't tell about that, so I assume the worst case.
You can easily format the cell to display nothing when the result of the calculation is zero. Just use a customized format 0.00,-0.00,. The first is used if the value is >0, the second when it's <0 and the last (plain nothing) when the value =0.
The problem is that this has effect for EVERY value of zero. If, for example, E5, F5, G5 and H5 are all 0 the result is zero, and you'll see nothing. And if they are empty, you'll see nothing also.
Your requirements can be interpreted as:
1. show nothing if ALL cells are empty (as asked in your post), or
2. show nothing if at least ONE of the cells is empty (not really asked, but different from #1), or
3. show nothing also if there's no empty cell, but the outcome of the formula is zero (as asked in your subject line)
If you want #1 or #2 you must use an IF-function, combined with ISEMPTY and AND or OR.
If you want #3, use the formatting I explained above.
Hope this helps.
I have a spreadsheet that uses the values in several other cells to calculate a value for a cell. This is an example from one cell: K5=E5*$E$3+F5*$F$3+G5*$G$3+H5*$H$3. How do I get the result cell, in this case K5, to display nothing instead of 0.00 when the cells used to create the formula have no values? I thought about the IF function, but that seems like it would make a long formula even more complicated. Any suggestions? Thanks, Kay