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?
Click to expand...

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.
 
Top