View Single Post
  #4   Report Post  
Domenic
 
Posts: n/a
Default

Try custom formatting your cell...

Format Cells Number Custom Type: 0;-0;;@

Hope this helps!

In article ,
PokerZan
wrote:

I think a quick question here...

I have a rather lengthy SUMPRODUCT formula that I want to leave a blank
cell if the product of my criteria is zero. Is there a way to do this?
It seems to me that I have seen folks post here about a IFISERROR or
something like that, but I thought that was to return a blank in
VLOOKUP #N/A result. This is pretty similar but I can't seem to figure
out how to get it done.

Thanks,

PZan