# Calculate depreciation

#### anillinda

##### New Member
 asset date purchased cost prior life current depreciation Ipad 08/5/1996 2548 1687 5

<tbody>
</tbody>

I am using the folliowing formula:
=INT(ROUND(IF(C4<(EDATE(\$B\$1,-12)+1),SLN(D4,0,F4),IF(AND(C4>=EDATE(\$B\$1,-12)+1,C4<=\$B\$1),SLN(D4,0,F4)/12*(DATEDIF(C4,\$B\$1,"m")))),0))

The result is incorrect
cell b1 has value "07/31/18"
Help would be appreciated, specially in calculating depreciation when the final depreciation is in the last year

### Excel Facts

Can you sort left to right?
To sort left-to-right, use the Sort dialog box. Click Options. Choose "Sort left to right"

#### jorismoerings

##### Well-known Member
Hi,

take a look at this and see if this helps:

Replies
3
Views
149
Replies
1
Views
396
Replies
1
Views
419
Replies
2
Views
95
Replies
7
Views
55

1,129,530
Messages
5,636,861
Members
416,946
Latest member
mniceguy81

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back