Number Of Period Required To Pay Off Debt – Excel Finance Function Challenge

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.


You may also like

February 17, 2022

Edit Excel Formulas in WORD – Spreadsheet Tips and Tricks

February 8, 2021

51: Oz du Soleil & the Global Excel Summit 2021

January 29, 2021

Global Excel Summit 2021

January 22, 2021

50: Randy Austin – Excel for Freelancers

January 8, 2021

49: Theresa Estrada – Microsoft Principal Program Manager Lead

May 26, 2020

All Excel LOOKUPs Explained
  • 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.

  • {"email":"Email address invalid","url":"Website address invalid","required":"Required field missing"}

    Free Power User Quick Guide

    Discover The BEST Ways To Use Lookups And Conditional Calculations Quickly And Easily With This Reference Guide -- You Won’t Want This To Leave Your Side

    With so many ways to use Excel, it can be difficult to memorize all of the key functions, calculations, and techniques you can employ to meet your goal: simply get the job done.