Show cell empty when 0

W

WH99

I have the following formulas:

Down column B:
=SUMPRODUCT(--(MONTH(MAIN!$A$10:$A$4999)=MONTH($G$1)),--(DAY(MAIN!$A$10:$A$4999)=DAY($A1)),MAIN!$D$10:$D$4999)

Down column C: C1 =B1 then C2 onwards =SUM(C1+B2)

How do I get both columns to show an empty cell if the figure is zero?
 
L

Lorne

WH99 said:
I have the following formulas:

Down column B:
=SUMPRODUCT(--(MONTH(MAIN!$A$10:$A$4999)=MONTH($G$1)),--(DAY(MAIN!$A$10:$A$4999)=DAY($A1)),MAIN!$D$10:$D$4999)

Down column C: C1 =B1 then C2 onwards =SUM(C1+B2)

How do I get both columns to show an empty cell if the figure is zero?

Look at the custom options in format cells. You need to create something
like this:

'#,##0;-#,##0; '

without quotes. The first & second entries format positive + negative
numbers. The third formats zero - in this case it is a space. Replace the
first 2 with whatever you want (see the custom list if you need date formats
etc.
 

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

Top