Question: what is npery in excel?
Answer: The Excel EFFECT function returns the effective annual interest rate, given a nominal interest rate and the number of compounding periods per year. ... npery - Number of compounding periods per year.