It's hard to tell without seeing your formula, but one would be

=IF(your_formula=0,"",your_formula)


Regards,

Peo Sjoblom

"Danny J" wrote:

Hi all,

OK I have the sumproduct working well, which is great....but how do I set it
up so that if the result is going to be 0 the cell appears blank....I have
bashed my brains with IF statements (the way I normally do this) but I don't
think it will work.

Any ideas?

Danny