Cumulative formula - can't figure it out!

[jon1315]

Hi all
Unfortunately I can't get my XL2BB to run so apologies in advance for the screenshot.

I'm trying to calculate reducing balance depreciation in column M. I have split it out by month in columns O onwards, and I'm happy with how that works.
Ideally, I'd like to be able to calculate for any given month in column L, so in the example where L4 =1, M displays 492.57, but if the following month (where L4 becomes 2) M would become 741.22. I would like to delete columns O onwards completely and just have cumulative running from one column.

I've been stuck on this one for a while- if anyone could point me in the right direction I'd appreciate it!

 

[Peter_SSs]

Unfortunately I can't get my XL2BB to run

Assuming that you have carefully followed the installation and usage instructions here, I suggest that you post a thread in the About This Board forum stating exactly where in the process something is going wrong and what the symptoms are for you.