Excel TV ExcelTV
Excel Functions & Formulas

NPER Function: Periods to Pay Off Debt in Excel

Updated
NPER Function: Periods to Pay Off Debt in Excel

Hundreds Of Millions Guess Wrong

In our last episode, Jordan poses the question: Which Version of Excel has the Hall of Tortured Souls Easter Egg?

Of the alleged millions of Excel TV viewers that pondered the previous episodes challenge there were exactly zero correct answers.

Congrats: No One

You are the winner of Nothing.

Your Mom will be so proud.  The answer was Excel 95.

What Version Of Excel Had An Easter Egg Featuring The Hall Of Tortured Souls?

DataPig Contest Winner

In our previous episode, Michael Alexander of DataPigTechnologies and the Bacon Bits Blog offered a contest where he would give away a complimentary ticket to his Power BI Bootcamp in Dallas Texas to a person at random that mention “ice cream sandwich” in the comments section of the episode.  Yes… you read that right.

The winner was Alex Powers. Congrats Alex.

This Weeks’ Challenge

What Financial Function Returns The Number Of Periods To Pay Off A Debt?

The winner of the challenge will win an ebook version of Jordan’s new book, Dashboards for Excel.

So How Do I Win?

Leave that guess below.  Jordan will pick a winner randomly from all the correct answers.

Written by

Rick Grantham
Rick GranthamSix Sigma Black BeltCo-founder, Excel TV

Business Intelligence Product Manager, VENUS Fashion Inc.

  • Business Intelligence
  • Data Analytics
  • Strategy
  • Team Building
Rick Grantham, a Six Sigma Black Belt and co-founder of Excel.TV in 2014, is currently serving as the Business Intelligence Product Manager at VENUS Fashion Inc. since March 2023. He has extensive experience in data analytics, strategic thinking, and team building, having held various leadership roles in renowned companies, such as Vice President of VantagePoint Business Solutions and Senior Director of Business Intelligence Solutions at EPI-USE. With a strong background in creating data-driven solutions and improving business processes, Rick has consistently demonstrated success in delivering exceptional results and boosting revenue throughout his career.

Read more articles by Rick Grantham

Editorial standards

Fact Checking & Editorial Guidelines

Every article on Excel TV is held to a published editorial standard. The goal: accurate, current, and useful — without filler.

  1. Expert review. Drafts on technical Excel topics are reviewed by a contributor with hands-on, working knowledge of the feature being covered.
  2. Source validation. Claims about Excel behavior are tested in current Microsoft 365 builds. Third-party product claims are sourced from the vendor's own documentation.
  3. Disclosure. Affiliate links, sponsorships, and any commercial relationships that influenced a piece are disclosed in-line and at the foot of the article.
  4. Updates. Articles are revisited when Microsoft ships changes that affect the content. The most recent revision date is shown on every post.

Spot a problem? Email editor@excel.tv and we will look at it.

Subject-matter review

Reviewed by Subject Matter Experts

Technical Excel articles are reviewed by contributors with verifiable, hands-on experience in the topic — not generalist editors.

  • Qualified reviewers. Reviewers include Microsoft Excel MVPs, working business-intelligence practitioners, and Excel TV editorial staff. See each author's page for credentials.
  • Current to a known Excel build. Procedural articles state which Excel version they were validated against. Where Microsoft has since changed behavior, the article carries an inline update note.
  • Clarity check. Reviewers verify steps are reproducible by a reader at the assumed skill level — not just technically correct in a vacuum.

Want to contribute or review for Excel TV? See the about page.

Comments (2)

Historical comments preserved from the WordPress archive. Commenting is no longer active.

  1. Bill

    nper is the answer this week.

    I’ve just found your site within the past month and really enjoy it so far. Keep up the good work.

  2. Ryan Tretter

    Nper