View Single Post
  #6   Report Post  
Gord Dibben
 
Posts: n/a
Default

Myrna

Assuming you have =B2-A2 in Column C(copied down, of course)

In D2 enter =C2

In D3 enter =D2+C3 and drag/copy down column D

Gord Dibben Excel MVP

On Sun, 7 Nov 2004 12:33:03 -0800, "Myrna"
wrote:

Register Bank Cash Cumm Cash
Money Deposit Over (over short)
(short)

$704.89 $704.32 $-0.57 $0.57
$766.86 $769.44 $+2.58 $2.01
$563.71 $563.61 $-0.10 $1.91
$678.18 $677.86 $-0.32 $1.59
$875.26 $875.15 $-0.11 $1.48

How do I create the formula for the last column. Having troubles if the
column before is a positive number to add, but is negative I have to subtract.

Myrna