Look Who it Was Random video

Excel - Prevent Incorrect Calculations in Excel: Solving the Future Game Issue - Episode 1041

258 views · Published 22 June 2009 · 2:21 · Indexed 20 September 2026

Channel: MrExcel.com · 2009 · Education

Watch on YouTube

Microsoft Excel Tutorial - Prevent Incorrect Calculations in Excel: Solving the Future Game Issue.

Welcome to the MrExcel Netcast, where we tackle your toughest Excel questions and provide you with the solutions you need. In this episode, we're diving into the world of sports data analysis with a question from Mario about tracking football (or soccer) results. Mario has a formula that works well for calculating points based on wins, losses, and ties, but he's running into an issue with future games. How can he prevent the formula from calculating a tie when the score is not yet filled in? 

To solve this problem, we'll introduce the ISBLANK function. By editing Mario's formula to include this function, we can ensure that the formula only calculates when the score is filled in. This means that for future games, the result will show up as blank until the score is entered. This is a great way to prevent incorrect calculations and ensure accurate data analysis. 

But that's not all - we'll also explore the option of checking for ties first in the formula, rather than last. This can provide a different approach to solving the problem and may be a better fit for certain data sets. As always, we'll walk you through the steps and provide you with the tools you need to confidently tackle similar issues in your own Excel projects. 

Thank you for tuning in to this episode of the MrExcel Netcast. We hope you found the solution to Mario's question helpful and informative. Don't forget to subscribe to our channel for more Excel tips, tricks, and solutions. And if you have a tough Excel question of your own, be sure to send it our way - we love a good challenge! Until next time, happy Excel-ing!"

Buy Bill Jelen's latest Excel book: https://www.mrexcel.com/products/latest/

You can help my channel by clicking Like or commenting below: https://www.mrexcel.com/like-mrexcel-on-youtube/


Mario has built a great nested IF formula for assigning points to soccer games. However, the formula is calculating 1 point for both teams for all unplayed games. In Episode 1041, I take a look at how to modify the original formula to calculate nothing until a score has been entered.

Table of Contents:
(00:00) Introduction to the MrExcel Netcast
(00:12) Question from Mario about tracking soccer results
(00:22) Explanation of points system for soccer matches
(00:32) Nested IF statements for calculating points
(00:55) Issue with future games and calculating points
(01:13) Introduction to the ISBLANK function
(01:32) Using ISBLANK to prevent calculation until values are filled in
(01:59) Clicking Like really helps the algorithm

#excel #microsoft #microsoftexcel #exceltutorial #exceltips #exceltricks #excelmvp #freeclass #freecourse #freeclasses #excelclasses #microsoftmvp #walkthrough #evergreen #spreadsheetskills #analytics #analysis #dataanalysis #dataanalytics #mrexcel #spreadsheets #spreadsheet #excelhelp #accounting #tutorial 

This video answers these common search terms:
Calculating points for a win, loss, and tie in soccer
Editing formulas with ISBLANK function
Getting blank results for unfilled scores in future games
How to track football/soccer results using formulas
MrExcel Netcast with Bill Jelen
MrExcel Netcast: Advanced Excel functions and techniques
Nested IF statements in Excel
Preventing calculation of 1 as a result for future games
Tips for efficient data analysis in Excel
Using IF formulas with ISBLANK for accurate calculations
Using the ISBLANK function in Excel
YouTube video on analyzing data with pivot tables

Join the MrExcel Message Board discussion about this video at https://www.mrexcel.com/board/threads/1152468/

More from this channel