ok more on sumproduct

D

Danny J

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
 
P

Peo Sjoblom

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

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


Regards,

Peo Sjoblom
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Mac Excel 2011 and MS Excel 2007 #N/A 0
Multiple arguments 3
Sumproduct Problem 1
Prompt For Replace in Selection And More... 0
Cell data entering slow! 0
Possible Sumproduct with Or Function 1
Count Number of Unique Cells That Don't Have Certain Characters 0
sumproduct issues 1

Top