Formula

M

Maxine

I have a depreciation project and I am trying to find a formula that will
result in the last year's amount. Using straight line depreciation, I have a
formula that removes 1 month of depreciation in the first year. The formula
I need should give one of two results, either a full year's worth of
depreciation or the remaining amount in the last year.

This is the formula I have so far
IF(C18>SLN($F$5,$F$6,$F$7),""<SLN($F$5,$F$6,$F$7)),IF(C18<SLN($F$5,$F$6,$F$7*12))

Can anyone help?
 
G

Gary Brown

Cost in Cell F5
Salvage in Cell F6
Life in Cell F7
Months of Depr to
be removed in Cell F8

Formula:
=SLN(F5,F6,F7)-(SLN(F5,F6,F7)*(F8/12))

--
Hope this helps.
If this post was helpfull, please remember to click on the ''''YES''''
button at the bottom of the screen.
Thanks,
Gary Brown
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top