Go Back   Talk Microsoft > Microsoft Operating Systems & Software > Microsoft Office Family

Reply
     Need some Microsoft Excel help?  
LinkBack Thread Tools Display Modes
  #1 (permalink)  
Old 11-17-2007, 10:24 PM
Junior Member
 
Join Date: Nov 2007
Posts: 1
Default Need some Microsoft Excel help?

I'm making a personal finance spreadsheet and I have a balance column like in a checkbook. I want cell in that column to add the two cells to the left of it, and the one above it. (Credit + Debit + Previous Balance) What would be the formula for this?
Reply With Quote
Links
  #2 (permalink)  
Old 11-17-2007, 10:39 PM
Junior Member
 
Join Date: Oct 2007
Posts: 9
Default

Hypothetically assuming you are putting the balance formula in cell E2:

=C2+D2+E1

If your debits are not entered as negative numbers, then change the formula to...
=C2-D2+E1
...so that you are actually subtracting your debits from the balance
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT -4. The time now is 01:38 AM.