formula for check book

[Guest]

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.

 

[Guest]

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

 

[Bob Phillips]

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

 

[David McRitchie]

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.

--