hellosajjad
Board Regular
- Joined
- Jun 19, 2007
- Messages
- 83
As on
31/12/2006
Code Asset Valuation Pur. Date Acc. Dep
A001 Furniture 173,995 2001, 31 -Dec.
if((E2-D4)>=1826,C4,if(E2>D4,C4/5*(E2-D4)/365,0),(E2>D4,C4/5*(E2-D4)/365)))
This formula is not working,
I want to calculate Accumulated depreciation in this way,
if E2 is lesser than D4, no depreciation
if E2 is greater than D4, then calculate Accumulated Depreciation for the period.
C4/5*(E2-D4)/365
but if E2 - D4 is greater than 1825 then just write C4 (value in C4)
I mean Accumulated depreciation should not more than value of asset.
31/12/2006
Code Asset Valuation Pur. Date Acc. Dep
A001 Furniture 173,995 2001, 31 -Dec.
if((E2-D4)>=1826,C4,if(E2>D4,C4/5*(E2-D4)/365,0),(E2>D4,C4/5*(E2-D4)/365)))
This formula is not working,
I want to calculate Accumulated depreciation in this way,
if E2 is lesser than D4, no depreciation
if E2 is greater than D4, then calculate Accumulated Depreciation for the period.
C4/5*(E2-D4)/365
but if E2 - D4 is greater than 1825 then just write C4 (value in C4)
I mean Accumulated depreciation should not more than value of asset.