!rate,nper,pmt,pv,type!!Returns the future value of an investment based on periodic, constant payments and a constant interest rate!is the interest rate per period. For example, use 6%/4 for quarterly payments at 6% APR!is the total number of payment periods in the investment!is the payment made each period; it cannot change over the life of the investment!is the present value, or the lump-sum amount that a series of future payments is worth now. If omitted, Pv = 0!is a value representing the timing of payment: payment at the beginning of the period = 1; payment at the end of the period = 0 or omitted!
range,criteria!Counts the number of cells within a range that meet the given condition!is the range of cells from which you ...
range,criteria,average_range!Finds average(arithmetic mean) for the cells specified by a given condition or criteria!is the ...
range,criteria,sum_range!Adds the cells specified by a given condition or criteria!is the range of cells you want evaluated!is ...
rate,nper,pmt,fv,type!Returns the present value of an investment: the total amount that a series of future payments is worth ...
rate,nper,pmt,pv,type!Returns the future value of an investment based on periodic, constant payments and a constant interest ...
rate,nper,pv,fv,type!Calculates the payment for a loan based on constant payments and a constant interest rate!is the interest ...
rate,nper,pv,start_period,end_period,type!Returns the cumulative interest paid between two periods!is the interest rate!is ...
rate,nper,pv,start_period,end_period,type!Returns the cumulative principal paid on a loan between two periods!is the interest ...
rate,per,nper,pv!Returns the interest paid during a specific period of an investment!interest rate per period. For example, ...