Thread: DB Function?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
[email protected][_2_] cjwenngatz@gmail.com[_2_] is offline
external usenet poster
 
Posts: 16
Default DB Function?

I have a list of assets in column A.
Column B contains a historical date (Jan, 2008)
Column C contains current months date (Nov, 2009).
Column D shows the period difference (B-C) = 21

Now here comes the fun part, I need to know what the NBV of the asset
is using 20% declining balance). This formula will be copied to
multiple assets, so it needs to be dynamic.

I've tried everything I can think of :S

Thanks!