Mahmoudelnemr
New Member
- Joined
- May 14, 2019
- Messages
- 5
The attached table, first column is the truck code,3rd column is the price of new tires, the 4th column is the depreciation cost
https://photos.app.goo.gl/Gtt76KvF51Yt8xCi8
I want to depreciate the cost of new tire over 26
months
So i made a formula for the 4th column
=IF(A2=A1,D2/26+E1,D2/26)
If same truck id sum the depreciation of different tires for the same truck
The problems is that after the 26 months, the formula contunues to add depreciation cost, i want it to stop after 26 months
Any help
https://photos.app.goo.gl/Gtt76KvF51Yt8xCi8
I want to depreciate the cost of new tire over 26
months
So i made a formula for the 4th column
=IF(A2=A1,D2/26+E1,D2/26)
If same truck id sum the depreciation of different tires for the same truck
The problems is that after the 26 months, the formula contunues to add depreciation cost, i want it to stop after 26 months
Any help