Writing a checkbook and need to take the balance in the worksheet and either
add or subtract a cell value from the balance depending on if it is a Debit
or credit whech will both be on the same line. Thanks in advance.

To explain better, in one cell I need a formula that will add or subtract,
depending which cell is filled in. Hope this helps.

"Mike Busch" wrote:

Writing a checkbook and need to take the balance in the worksheet and either
add or subtract a cell value from the balance depending on if it is a Debit
or credit whech will both be on the same line. Thanks in advance.

=C2+a3-B3

where C2 is the previous balance, credits in A3, debits in B3

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Mike Busch" wrote in message
...
To explain better, in one cell I need a formula that will add or subtract,
depending which cell is filled in. Hope this helps.

"Mike Busch" wrote:

Writing a checkbook and need to take the balance in the worksheet and
either
add or subtract a cell value from the balance depending on if it is a
Debit
or credit whech will both be on the same line. Thanks in advance.

Hi Mike, and Bob,
If you actually write the formula like that you will not be able to insert
rows or delete rows (or for that matter sort rows), so ...

Would suggest using OFFSET in your formula, but see
http://www.mvps.org/dmcritchie/excel/insrtrow.htm
http://www.mvps.org/dmcritchie/excel/offset.htm
for some additional aspects that you might want to consider
for a checkbook balance.

--
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Bob Phillips" wrote in message ...
=C2+a3-B3

where C2 is the previous balance, credits in A3, debits in B3

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Mike Busch" wrote in message
...
To explain better, in one cell I need a formula that will add or subtract,
depending which cell is filled in. Hope this helps.

"Mike Busch" wrote:

Writing a checkbook and need to take the balance in the worksheet and
either
add or subtract a cell value from the balance depending on if it is a
Debit
or credit whech will both be on the same line. Thanks in advance.