The syntax of the function is. The formula in B7 is NPERB1B2B3B4B5. How NPER calculator works.
This is the interest rate per period.
As a worksheet function the NPER function can be entered as part of a formula in a cell of a worksheet. The NPER function will help us know the number of periods required to reach our target amount. Rate it the rate of the interest per period. Sandeep is paying installment monthly.