nper function

Occasional Contributor

nper function in financial formulas is returning incorrect values  - tested against many online calculator plus grandaddy of formulas (James C. VanHorn, Financial Management and Policy). Thanks. John

2 Replies

@John_Oakey Hello! Thanks for your question - you originally posted it as a comment on a March 2020 Tech Community weekly roundup, so based on the content I assumed it belonged in the Microsoft Excel discussion space. 


Please let me know if that is incorrect for any reason, and please post future Excel questions there. Thanks!

Hi Eric, after a lot of cross discussion it turns out that the problem is not Excel's formula but its documentation, which is either missing or incorrect. Unless you consider Excel's implicit-by-example instructions as correct, then the formulas for nper in Pv and Fv are reversed.
John Oakey