hi,
Assiming that the last column is D,In cell D1, you have shown $0.57 instead
of -$0.57
K.S.Warrier
"Gord Dibben" wrote:
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
|