[TABLE="width: 500"]
<tbody>[TR]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[TD]F[/TD]
[TD]G[/TD]
[TD]H[/TD]
[TD]I[/TD]
[/TR]
[TR]
[TD]No[/TD]
[TD]Description[/TD]
[TD]Date Purchased[/TD]
[TD]Cost[/TD]
[TD]Prior Depreciation[/TD]
[TD]Life[/TD]
[TD]Current Depreciation[/TD]
[TD]Type[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Truck[/TD]
[TD]09/3/2014[/TD]
[TD]28182[/TD]
[TD]16438[/TD]
[TD]5[/TD]
[TD]?[/TD]
[TD]Auto[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
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>
<tbody>[TR]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[TD]F[/TD]
[TD]G[/TD]
[TD]H[/TD]
[TD]I[/TD]
[/TR]
[TR]
[TD]No[/TD]
[TD]Description[/TD]
[TD]Date Purchased[/TD]
[TD]Cost[/TD]
[TD]Prior Depreciation[/TD]
[TD]Life[/TD]
[TD]Current Depreciation[/TD]
[TD]Type[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Truck[/TD]
[TD]09/3/2014[/TD]
[TD]28182[/TD]
[TD]16438[/TD]
[TD]5[/TD]
[TD]?[/TD]
[TD]Auto[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
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: