Formula help on a cell

[Guest]

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

 

[bpat1434]

Don't know if excel has it (though it should) have you tried looking fo
an Absolute Value to use

 

[Frank Kabel]

Hi
have you entered the data with a preceding $ sign? or have you importe
this data?

 

[Ragdyer]

No, you really don't have to subtract.
2 PLUS -1 equals 1

So, in D1 enter:
=C1

And in D2 enter:
=C2*(C2<>"")+D1

And drag down to copy as needed.

This will repeat the last calculation to any empty rows that do not have any
figures entered yet.

If you would prefer to see zeroes for these as yet not entered rows, try
this formula in D2:
=(C2<>"")*(C2+D1)

 

[Guest]

Frank,
I have the cell property set on currency for the cell. I manually type in
the data before the column for this calculation

 

[Gord Dibben]

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

 

[Guest]

hi,
Assiming that the last column is D,In cell D1, you have shown $0.57 instead
of -$0.57
K.S.Warrier