I would like to calculate current depreciation which should not exceed the cost of the asset, which is in cell b2.
Thanks.
The current depreciation is being calculated as under:
=IF(A8="","",ROUND(IF(A8=1,SLN($B$2,0,$B$3)/12*DATEDIF($B$4,$B$6,"M"),SLN($B$2,0,$B$3)),0))
<tbody>
A
B
C
D
E
F...