Cell Formula

[agonysWeeper]

A1 = 0 and C1 = -1,500
A2 = 0 and C2 = =IF(A2=0,0,C1+A2)
A3 = 300 and C3 = =IF(A3=0,0,C1+C2+A3)
A4 = 500 and C4 = =IF(A3=0,0,C1+C2+C3+A4)

then the column C looks like this
C1 = -1,500
C2 = blank
C3 = -1,200
C4 = -2,200 (I got error in C4 cause I want the total is -900)
can anyone give me correct formula?
Thanks

 

[Sektor]

I got no error. How did you get -900?

 

[moonfish]

I don't understand how you want it to be -900. If you want the cumulative value while ignoring zeroes you should refer to column A instead of column C:

Excel Workbook
	A	B	C
1	0	*	-1500
2	0	*	0
3	300	*	-1200
4	500	*	-700
Sheet1

However, this is -700 and not -900.

 

[anandvarma]

A1 = 0 and C1 = -1,500
A2 = 0 and C2 = =IF(A2=0,0,C1+A2)
A3 = 300 and C3 = =IF(A3=0,0,C1+C2+A3)
A4 = 500 and C4 = =IF(A3=0,0,C1+C2+C3+A4)

then the column C looks like this
C1 = -1,500
C2 = blank
C3 = -1,200
C4 = -2,200 (I got error in C4 cause I want the total is -900)
can anyone give me correct formula?
Thanks

no error in the formula
there seems to be error in logic it self in the data

 

[agonysWeeper]

I don't understand how you want it to be -900. If you want the cumulative value while ignoring zeroes you should refer to column A instead of column C:

Excel Workbook
	A	B	C
1	0	*	-1500
2	0	*	0
3	300	*	-1200
4	500	*	-700
Sheet1

However, this is -700 and not -900.

Hi, sorry for the wrong input, anyway its -700
but this is my C4 formula =IF(A4=0,0,C1+C2+C3+A4) and I got -2200 but I need -700
If you have any idea or other formula, more appreciated. thanks

 

[moonfish]

I gave you the formulas, you quoted them. I don't know how to make it any more clear than I already have.

 

[Sektor]

moonfish, you got error in your post according to C4 formula:
C1+A2+A3+A4

In agonysWeeper original is:
C1+C2+C3+A4

 

[agonysWeeper]

I gave you the formulas, you quoted them. I don't know how to make it any more clear than I already have.

Hi, got your point, thanks for your revised formula.

 

[moonfish]

@Sektor: I know, there's an error in his formula and I fixed it. This usually leads to a formula being different.

I even explained why I did this in my first post.

He is trying to create a cumulative version of column A but he wants to display zero in column C if there is zero in column A. This means the traditional method is out of the question. For the record, here's the traditional method:

Excel Workbook
	A	B
1	0	-1500
2	0	-1500
3	300	-1200
4	500	-700
Sheet2