Excel Function : VDB

Download now!

Excel Function : VDB




Returns the depreciation of an asset for a specified or partial period by using a declining balance method

Microsoft Excel Reference Page


Syntax and Description of the VDB Excel Function

I am trying to use a VDB function to get the syntax of an excel function. I have tried the following: =vdb("get.syntax","isna") =vdb("get.syntax","if") =vdb("get.syntax","vdb") =vdb("get.syntax","vdb.excel") None of the above work. If I use the 'isna' function in the VDB function I get the following error:

Error: #NAME?

If I use the

About VDB Excel Function

The VDB function is used to calculate the value of a function at a given point using the Van der Waals equation of state. The syntax for the VDB function is as follows: VDB(P,T,R,b,c) where P is the pressure, T is the temperature, R is the gas constant, b is the van der Waals constant, and c is the molar volume.