View Single Post
  #3   Report Post  
Bob Phillips
 
Posts: n/a
Default

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