!rate,nper,pv,fv,type!!Calculates the payment for a loan based on constant payments and a constant interest rate!is the interest rate per period for the loan. For example, use 6%/4 for quarterly payments at 6% APR!is the total number of payments for the loan!is the present value: the total amount that a series of future payments is worth now!is the future value, or a cash balance you want to attain after the last payment is made, 0 (zero) if omitted!is a logical value: payment at the beginning of the period = 1; payment at the end of the period = 0 or omitted!
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, ...
rate,per,nper,pv,fv,type!Returns the interest payment for a given period for an investment, based on periodic, constant payments ...