If column value=0 next 2 column should be empty (or zero)

[nova_sweet]

Hi,

I wonder how it is possible to check let´s say A7:A31 and if there is a zero value in a cell the equival cell in columns B and C will be 0 too?

Best regards!

 

[seguin85]

What if it is not 0? What will the value of B and C become?

 

[nova_sweet]

Hello!

There is a formula that changes the values of the cells in B and C.
Like C1==SUM(A$1:A1)-1

 

[seguin85]

in cell c1 try:

=if(A1=0,0,sum(A$1:A1)-1)

Then copy down

 

[nova_sweet]

Thanks a lot! It works and was easy to transfer