Returns the number of cells in a column or database that contains numeric values and meets a given criteria.
How To Use: PV Function
Calculates the present value of a loan or an investment, based on a constant interest rate.
How To Use: CUMPRINC Function
Returns the cumulative principal paid on a loan between start_period and end_period.
How To Use: ACCRINTM Function
Returns the accrued interest for a security that pays interest at maturity.
How To Use: PRODUCT Function
Returns the product (multiplication) of a supplied set of numerical values.