# 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

Excel Joke
Why can't spreadsheets drive cars? They crash too often!

#### 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
556
Replies
3
Views
8K
Replies
8
Views
2K

1,148,108
Messages
5,744,878
Members
423,908
Latest member
Getfour

### 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