View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
BTR BTR is offline
external usenet poster
 
Posts: 9
Default Declining balance

this did not work. I typed in exactly what you have below (do I need to
insert the actual dollar amount where you have the $ sign?)

"Dave" wrote:

Ok, in K5 enter:
=IF(J5="","",$K$3-SUM($J$5:$J5))
Then fill down way past the bottom of your data in Column J
Let me know.
Dave.