Formula help on a cell
 

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

--
Thank you

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


--
bpat1434
------------------------------------------------------------------------
bpat1434's Profile: http://www.excelforum.com/member.php...o&userid=16155
View this thread: http://www.excelforum.com/showthread...hreadid=276075

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

--
Regards
Frank Kabel
Frankfurt, Germany


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

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)
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------


"Myrna" wrote in message
...
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

--
Thank you

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

"Frank Kabel" wrote:

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

--
Regards
Frank Kabel
Frankfurt, Germany


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

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

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