There are many hypotheses in science which are wrong. That's perfectly all right: it's the aperture to finding out what's right. Science is a self-correcting process.
I've done this before and I know that it works, but I cannot figure out what the problem is this time. I have three columns - column C is for Deposits, column D is for Checks Written, and column E is for the Balance. So, the balance on line 2 in column E is $50, then line 3 shows a check written for $10 (column D), and column C for Deposits is left blank, and then the formula in column E on line 2 is =sum(E2-D3+C3), and that works. However, when I get to line 3, no matter if I add or subtract first, it comes up with #VALUE. How can I make this work so that it will add and subtract all the way down the column, regardless of if I'm depositing or writing a check? Thanks - Donna Answer from Richard Rost:
The way you have it set up, E3 should be: =E2+C3-D3
Then E4 would be: =E3+C4-D4 Then E5 would be: =E4+C5-D5
It works fine for me. Just put the correct formula in E2 and AutoFill it down the column.
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Excel Forum.
