Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
BTR BTR is offline
external usenet poster
 
Posts: 9
Default Formulas--running balance

I have pasted below a problem that I have in setting formulas to give me a
running balance after each expenditure. Can anyone give me some simple
instructions in writing on how to do this?

Encumbered Running
or Paid Balance
$85,848.82

$1,222.19 $84,626.63
$916.00 $84,626.63
$1,048.80 $84,626.63
$377.00 $84,626.63
$62.70 $84,626.63
$400.85 $84,626.63
$180.00 $84,626.63
$479.07 $84,626.63
$177.84 $84,626.63
$84,626.63
$84,626.63
$84,626.63
$84,626.63
$84,626.63
$84,626.63
$84,626.63
$84,626.63
$84,626.63
$84,626.63
$84,626.63
$84,626.63

  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1,388
Default Formulas--running balance

Hi,
If your original balance ($85,848.82) is in A2 and your first expenditure is
in A4, then in B4 enter:
=IF(A4="","",$A$2-SUM($A$4:$A4)) and copy down.

Regards - Dave.
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Running Balance Victor Excel Discussion (Misc queries) 3 May 25th 08 09:51 PM
running balance PR Kid New Users to Excel 2 March 13th 08 09:13 PM
rent received/balance owed/running balance spreadsheet Quickbooks dummy Excel Discussion (Misc queries) 1 January 2nd 06 07:34 PM
How do i set up a running balance on one row? Jimmy James Excel Worksheet Functions 1 November 15th 05 07:08 PM
running balance Jackie New Users to Excel 9 January 7th 05 11:47 PM


All times are GMT +1. The time now is 04:56 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"