# VDB function

#### krp7168

##### New Member
Hi All,

I understand that if you set the no_switch argument of the VDB function to false, your calculation will switch to straight line (SLN) once SLN is great than the declining balance.

However, I cannot seem to get this to work. By way of example:

=SLN(2400,300,10) equates to 210 of depreciation expense per year (for ten years)

=VDB(2400,300,10,0,1,2,FALSE) equates to the following depreciation expenses per year:

Year 1 480.00
Year 2 384.00
Year 3 307.20
Year 4 245.76
Year 5 196.61
Year 6 157.29
Year 7 125.83
Year 8 100.66
Year 9 80.53
Year 10 22.12

My question is why doesn’t this formula switch to straight-line in year 5 when the VDB balance is obviously less than straight-line????

Any guidance would be much appreciated!

Kevin

### Excel Facts

Copy a format multiple times
Select a formatted range. Double-click the Format Painter (left side of Home tab). You can paste formatting multiple times. Esc to stop

#### sunnyland

##### Well-known Member
Hello again,

Sorry, I posted my previous post too quickly and only realised later it didn't paste all the rows. So here we are again.
The vdb function switches when the no switch off is less then the no switch on. See sample above. While in green both are similar with the blue it shows that switching to straight line is better greater amount of amortisation.

Replies
1
Views
883
Replies
3
Views
9K
Replies
8
Views
2K

Threads
1,182,187
Messages
5,934,152
Members
436,932
Latest member
Tuns

### 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.
Allow Ads at MrExcel

### Disable AdBlock

Follow these easy steps to disable AdBlock

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

### Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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