Need help in my Cell formula

[agonysWeeper]

C1 = 1,500
A2 = 0
C2 = IF(A2=0,0,C1+A2) which is total of 1,500 because the A2 is 0 but the cell show a 0.
A3 = 300
C3 = IF(A3=0,0,C2+A3) which is 300 but I am looking for 1,800

I want this set up.
C1 = 1,500
A2 = 0
C2 = -
A3 = 300
C3 = 1,800


Anyone help?

 

[njimack]

Enter the following into C2 and copy down as far as necessary:
=IF(A2,SUM(C$1:C1)+A2,0)

 

[jasonb75]

C3 = if(a3=0,0,c1+a2+a3)

 

[agonysWeeper]

Enter the following into C2 and copy down as far as necessary:
=IF(A2,SUM(C$1:C1)+A2,0)

This is working, but how about if C1 is (50,000), the next row will increase. if A2 = 300 C2 must be (49,700) and A3 = 500 C3 must be (49,200)
Please help again.

 

[jasonb75]

Neil,

Your answer got me thinking, I based mine purely on the example, but on the assumption that it is going to be copied down, I think maybe

=IF(A2,SUM(A$2:A2,$C$1),0)

Maybe we're both on the wrong track

 

[njimack]

This is working, but how about if C1 is (50,000), the next row will increase. if A2 = 300 C2 must be (49,700) and A3 = 500 C3 must be (49,200)
Please help again.

Can you explain clearly the logic behind the calculations? In your first example you wanted to include the value in C1, now you're excluding it.

 

[agonysWeeper]

C1 = 1,500
A2 = 0
C2 = IF(A2=0,0,C1+A2) which is total of 1,500 because the A2 is 0 but the cell show a 0.
A3 = 300
C3 = IF(A3=0,0,C2+A3) which is 300 but I am looking for 1,800

I want this set up.
C1 = 1,500
A2 = 0
C2 = -
A3 = 300
C3 = 1,800


Anyone help?

Just to change the value of C1= 1,500 to (1,500)
then A2 = 0
C2 = -
A3 = 300
C3 = (1,200)

Please help.

 

[njimack]

Just to change the value of C1= 1,500 to (1,500)
then A2 = 0
C2 = -
A3 = 300
C3 = (1,200)

Please help.

The original formula I provided will give you the desired results.

 

[njimack]

Neil,

Your answer got me thinking, I based mine purely on the example, but on the assumption that it is going to be copied down, I think maybe

=IF(A2,SUM(A$2:A2,$C$1),0)

Maybe we're both on the wrong track

It's always interesting seeing how differently people interpret what posters are looking for.

 

[agonysWeeper]

The original formula I provided will give you the desired results.

There is something wrong because.

Just to change the value of C1= 1,500 to (1,500)
then A2 = 0
C2 = -
A3 = 300
C3 = (1,200)

Please help.

when it comes to C4 like for example I put a 300 again in A4 then C4 will show (2,400) but I am looking for (900) Please help again.