NPER
Definition: NPER is a function that calculates the number of payment periods for a loan or investment. Syntax: =NPER(rate, payment, present_value, [future_value], [type]) Situation: This formula is appropriate...