Sometimes, you may need to assign the points based on win/lose/tie results from a team. Here, we will show the simple formulas used to calculate the win-loss points in Excel. Let’s get into this article!! Get an official version of ** MS Excel** from the following link: https://www.microsoft.com/en-in/microsoft-365/excel
Generic Formula:
- You can use the below formula to calculate the win-lose points in Excel.
=VLOOKUP(result,points_table,2,0)
Syntax Explanations:
- VLOOKUP – This function is used to look up data in a range or table by row. Read more on the VLOOKUP Function.
- Result – It represents the criteria value for the input values.
- Point-Table – It represents the input table value.
- Comma symbol (,) – It is a separator that helps to separate a list of values.
- Parenthesis () – The main purpose of this symbol is to group the elements.
Practical Example:
Let’s consider the below image.
- First, we will enter the input values in Column B and Column C ** and the fixed result based on the score is given in **Column F and G.
- Here we want to declare the result based on their scores.
- Then apply the above-given formula to the formula bar section and press the “Enter” key.
- Finally, it will display the results in the selected cell.
Wrap-Up:
From this tutorial, you can get some clarification on how to calculate the win-loss points in Excel. Hope you like it. Let me know your comments in the below comment section. Thank you so much for visiting!! Click here to know more details Geek Excel *and Excel Formulas *!!
Top comments (0)