Excel Function : VDB

Excel Function : VDB

Category

Financial

Description

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

Microsoft Excel Reference Page

https://support.office.com/en-us/article/VDB-function-dde4e207-f3fa-488d-91d2-66d55e861d73

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.