View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
joel joel is offline
external usenet poster
 
Posts: 9,101
Default Adding up a loan

I have just taken out a loan and have now created my own spreadsheet to show
me how long I have got to pay it off.

I have 7 columns that show each of the years that it will take me to pay my
loan off. I have 12 rows showing the months of the year


Under each year and next to each month there is the amout I pay.

At the top I have to figures one shows How much I have left to pay. I want
the other to show how much I have paid so far.

So each time I set one of the amounts to zero I want it to add that amount
of to the amount I have paid off

Please help thanks
--
N/A