The DDB function calculates the depreciation of an asset in a given period using the double-declining balance method. The double-declining balance method computes depreciation at an accelerated rate – depreciation is highest in the first period and decreases in each successive period. To ...Read more
The Excel DB function returns the depreciation of an asset for a specified period using the fixed-declining balance method. The calculated depreciation is based on initial asset cost, salvage value, the number of periods over which the asset is depreciated and, optionally, the number of months...Read more
The Excel IMPOWER function returns a complex number raised to a given power. The complex number is input as text, and must be in the form x + yi or x + yj.
For example:
=IMPOWER("1+2i",2) // returns "-3+4i"
In the example shown,...Read more
The FIXED function converts a number to text, rounding to a given number of decimals. Like the Number format available on the home tab of the ribbon, the FIXED function will round the number as needed using the given number of decimal places. The main difference between applying a number format...Read more
The FORECAST.ETS function predicts a value based on existing values that follow a seasonal trend. FORECAST.ETS can be used to predict numeric values like sales, inventory, expenses, etc. with a seasonal pattern.
To calculate predicted values, FORECAST.ETS uses something called triple...Read more
The RRI function returns an equivalent interest rate for the growth of an investment. For example, to use RRI to calculate equivalent annual compound interest for a 1000 investment worth 1200 after five years you can use a formula like this:
=RRI(5,1000,1200...Read moreThe Excel SYD function returns the "sum-of-years" depreciation for an asset in a given period. The calculated depreciation is based on initial asset cost, salvage value, and the number of periods over which the asset is depreciated.
For example, for an asset with an initial cost of $10,...Read more
The Excel SLN function returns the depreciation of an asset for one period, calculated with a straight-line method. The calculated depreciation is based on initial asset cost, salvage value, and the number of periods over which the asset is depreciated.
For example, for an asset with an...Read more
The DELTA function tests two numeric values for equality. When values are equal, DELTA returns 1. When values are different, DELTA returns zero. As a result, DELTA can be used to easily count pairs of equal numbers.
For example:
=DELTA(5,4) //...Read moreThe Excel T function converts numbers, dates, and the logical values TRUE and FALSE into empty strings. Text values and errors are not converted and pass through unaffected. You can use the T function to remove values that are not text.
The T...Read more