!rate,nper,pmt,fv,type!!Returns the present value of an investment: the total amount that a series of future payments is worth now!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 an investment!is the payment made each period and cannot change over the life of the investment!is the future value, or a cash balance you want to attain after the last payment is made!is a logical value: payment at the beginning of the period = 1; payment at the end of the period = 0 or omitted!
range!Counts the number of empty cells in a specified range of cells!is the range from which you want to count the empty ...
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 ...