Adding and Subtracting in checkbook program

  • Thread starter Thread starter sadasiva
  • Start date Start date
S

sadasiva

I recently Dloaded from the MS template site an Excel Checkboo
spreadsheet program that is supposed to add and subtract credits an
debits - i thought this was supposed to happen automatically once dat
is entered but it seems to not be doing it - what is the command that
need to make the program calcualte

thank
 
Hi Sadasiva
Without knowing the cell references and the type of
spreadsheet it is a bit difficult to answer.
So,if Income is in Cell D2 and Expenditure is in E2 and
Balance is in F1, the formula in F2 would be.
=IF(D2>0,D2+F1,F1-E2), copy the formula down the column as
required.

HTH
Michael.
 
F9


: I recently Dloaded from the MS template site an Excel Checkbook
: spreadsheet program that is supposed to add and subtract credits and
: debits - i thought this was supposed to happen automatically once data
: is entered but it seems to not be doing it - what is the command that i
: need to make the program calcualte
:
: thanks
:
:
: ---
: Message posted
:
 
Back
Top