A | B | C | D | E | F | G | H | I |
No | Description | Date Purchased | Cost | Prior Depreciation | Life | Current Depreciation | Type | |
1 | Truck | 09/3/2014 | 28182 | 16438 | 5 | ? | Auto | |
<tbody>
</tbody>
I am using the following formula, which is giving me error. Can someone trace the mistake? Cell I2 has date 07/31/2018
IF((EDATE(I2,-12))< c4,(sln(d4,0,f4),0,if(and(c4 >=EDATE(I2,-12)+1,C4<=I2,SLN(D4,0,ROUNDUP(YEARFRAC(C4,DATE(IF(MONTH(C4) >7,YEAR(C4)+1,YEAR(C4)),7,31))*12,0)/12),0)))<c4,(sln(d4,0,f4),0,if(and(c4></c4,(sln(d4,0,f4),0,if(and(c4>
Last edited by a moderator: