Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula
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(C18SLN($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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula
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 "Maxine" wrote: 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(C18SLN($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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|