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?

 

[jasonb75]

There is something wrong because.



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.

(2,400) and (900) are not easily identifiable as negative values, (maybe clear to you, but most people use the format of -2400 and -900) it's so much easier to understand if you make your data clearer.

In addition, it saves you having to keep asking more questions and wait for more answers if you read all of the replies in the thread and try all of the suggestions given to you. That way you would have found the solution that was given to you nearly 3 hours ago which does what you're asking for.