Formula help on a cell

M

Myrna

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
 
B

bpat1434

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

Frank Kabel

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

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)
 
M

Myrna

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

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
 
K

K.S.Warrier

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