!rate,value1,value2,...!!Returns the net present value of an investment based on a discount rate and a series of future payments (negative values) and income (positive values)!is the rate of discount over the length of one period!are 1 to 254 payments and income, equally spaced in time and occurring at the end of each period!
rate,per,nper,pv!Returns the interest paid during a specific period of an investment!interest rate per period. For example, ...
rate,per,nper,pv,fv,type!Returns the interest payment for a given period for an investment, based on periodic, constant payments ...
rate,per,nper,pv,fv,type!Returns the payment on the principal for a given investment based on periodic, constant payments ...
rate,pmt,pv,fv,type!Returns the number of periods for an investment based on periodic, constant payments and a constant interest ...
rate,value1,value2,.!Returns the net present value of an investment based on a discount rate and a series of future payments ...
rate,values,dates!Returns the net present value for a schedule of cash flows!is the discount rate to apply to the cash flows!is ...
real_num,i_num,suffix!Converts real and imaginary coefficients into a complex number!is the real coefficient of the complex ...
reference!Returns the column number of a reference!is the cell or range of contiguous cells for which you want the column ...
reference!Returns the number of areas in a reference. An area is a range of contiguous cells or a single cell!is a reference ...