Excel VDB Function

Excel VDB Function

The VDB function is a Finance function that calculates the depreciation of an asset on the double-declining balance or another basis for a specified period. The VDB stands for variable declining balance and the function switches to straight-line depreciation when...
Excel DDB Function

Excel DDB Function

The DDB function is a Finance function that calculates the depreciation of an asset on the double-declining balance or another basis for a specified period. In this guide, we’re going to show you how to use the DDB function and go over some tips and error handling...
Excel DB Function

Excel DB Function

DB The DB function is a Finance function that calculates the depreciation of an asset on the fixed-declining balance basis for a specified period. In this guide, we’re going to show you how to use the DB function and go over some tips and error handling methods....
Excel SYD Function

Excel SYD Function

The SYD function is a Finance function that calculates the depreciation of an asset on the sum-of-years' digits basis for a specified period. In this guide, we’re going to show you how to use the SYD function and go over some tips and error handling methods. Supported...
Excel SLN Function

Excel SLN Function

The SLN function is a Finance function that calculates the depreciation of an asset on a straight-line basis for one period. In this guide, we’re going to show you how to use the SLN function and go over some tips and error handling methods. Supported versions All...
Function: QUOTIENT

Function: QUOTIENT

QUOTIENT is a Math and Trigonometry function which calculates and returns the integer portion of a division. This function can be especially useful for when you want to discard the remainder of a division, and not any of the values. In this guide, we’re going to show...
Function: VARPA

Function: VARPA

The VARPA function is a statistical function that can calculate and return the variance of a population by evaluating text and logical values. Variance provides a general idea of how much data points are spread in a data set, and can be used to calculate the standard...
Function: VARA

Function: VARA

The VARA function is a statistical function that can calculate and return the variance of a sample by evaluating text and logical values. Variance provides a general idea of how much data points are spread in a data set, and can be used to calculate the standard...
Function: VARP

Function: VARP

The VARP function is a statistical function calculates and returns the variance of a population. Variance provides a general idea of how much data points are spread in a data set, and can be used to calculate the standard deviation or determine the risk of an...