The Excel IMSIN function returns the sine of a complex number. For instance, given "1+1i" as input, the function returns the complex number equal to the sine of the input.
=IMSIN("1+1i") // returns 1.29845758141598+0.634963914784736i
Given...Read more
The Excel IMCOS function returns the cosine of a complex number. For instance, given “1 + 1i” as input, the function returns a complex number equal to the cosine of the input.
=IMCOS(COMPLEX(1,1)) // returns 0.833730025131149-0.988897705762865i...Read moreThe ISPMT function calculates the amount of interest in a given period of an investment where principal payments are equal. The given period is specified as a zero-based number instead of a 1-based number. For example, to calculate the interest amount in payments for a loan where the amount is $...Read more
The FACTDOUBLE function returns the double factorial of a number. A double factorial is calculated differently for even and odd numbers. For an even number, n, it's the product of all even integers less than or equal to n and greater than or equal to 2. For...Read more
The FORECAST function predicts a value based on existing values along a linear trend. FORECAST calculates future value predictions using linear regression, and can be used to predict numeric values like sales, inventory, test scores, expenses, measurements, etc.
Note: Starting...Read more
The FORECAST.LINEAR function predicts a value based on existing values along a linear trend. FORECAST.LINEAR calculates future value predictions using linear regression, and can be used to predict numeric values like sales, inventory, test scores, expenses, measurements, etc.
...Read more
The LINEST function returns statistics for a best fit straight line through supplied x and y values. The values returned by LINEST include slope, intercept, standard error values, and more, up to 10 different statistics in total. To find the best fit...Read more
The VDB function returns the depreciation of an asset for a given period, using the double-declining balance method or another method specified by changing the factor argument. By default, the VDB function will switch to straight line...Read more
The Excel NOMINAL function calculates the nominal interest rate when given an effective annual interest rate and the number of compounding periods per year. Nominal interest rate is typically the stated rate on a financial product. Effective annual interest rate is the interest rate actually...Read more
The EFFECT function calculates the effective annual interest rate, given a nominal interest rate and the number of compounding periods per year. Nominal interest rate is the stated rate on the financial product. Effective annual interest rate is the interest rate actually earned due to...Read more