checkbook info.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm trying to set up a checkbook in excel. I have it set up to have withdrawl in column D,Deposit in column C and Balance in E
Where do I put the formula and what formula do I use?
 
Marty, Here is one way, assuming that you have a starting balance in E2 in
E3 put =(IF(OR(C3,D3>0),E2-D3+C3,"")) and copy down

You may also want to look at one here http://redirx.com/?vnj

Also I have a file set up, if you would like to take a look let me know and
I will send you a copy

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 97 & 2000
** remove news from my email address to reply by email **


Marty said:
I'm trying to set up a checkbook in excel. I have it set up to have
Click to expand...
withdrawl in column D,Deposit in column C and Balance in E.
 
Formula goes into Col E

Starting balance is Hardcoded into say Row 3 Colum E
In Row 4 Colum E enter =e3+c4-d4
Copy this cell and paste down col E row 5 and below




: I'm trying to set up a checkbook in excel. I have it set up to have withdrawl
in column D,Deposit in column C and Balance in E.
: Where do I put the formula and what formula do I use?
 
Why not just =e2+c3-d3?


: Marty, Here is one way, assuming that you have a starting balance in E2 in
: E3 put =(IF(OR(C3,D3>0),E2-D3+C3,"")) and copy down
:
: You may also want to look at one here http://redirx.com/?vnj
:
: Also I have a file set up, if you would like to take a look let me know and
: I will send you a copy
:
: --
: Paul B
: Always backup your data before trying something new
: Please post any response to the newsgroups so others can benefit from it
: Feedback on answers is always appreciated!
: Using Excel 97 & 2000
: ** remove news from my email address to reply by email **
:
:
: : > I'm trying to set up a checkbook in excel. I have it set up to have
: withdrawl in column D,Deposit in column C and Balance in E.
: > Where do I put the formula and what formula do I use?
:
:
 
Lady Layla, if you use =e2+c3-d3 you will see the balance all the way down
the sheet for how far you copied the formula down, using
=(IF(OR(C3,D3>0),E2-D3+C3,"")) will hide that so if column C or D does not
have a valve you want see anything in column E on that row
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 97 & 2000
** remove news from my email address to reply by email **
 
Back
Top