Excel Formula to Calculate the Win-Loss Points ~ Easy Guide!!
Tags: excelformula, excelformulas
Published: 2021-03-05 12:01:41

---
title: Excel Formula to Calculate the Win-Loss Points ~ Easy Guide!!
published: true
date: 2021-03-05 07:03:54 UTC
tags: ExcelFormula,Excelformulas
canonical_url: https://geekexcel.com/excel-formula-to-calculate-the-win-loss-points-easy-guide/
---

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](https://www.microsoft.com/en-in/microsoft-365/excel)

[![Win Lose calculations](https://geekexcel.com/wp-content/uploads/2021/03/Win-Lose-calculations.png)](https://geekexcel.com/excel-formula-to-calculate-the-win-loss-points-easy-guide/win-lose-calculations/#main)<figcaption id="caption-attachment-22204">Win Lose calculations</figcaption>

## Generic Formula:

- You can use the below formula to calculate the win-lose points in Excel.

**=[VLOOKUP](https://geekexcel.com/how-to-use-excel-vlookup-function-in-office-365/)(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**](https://geekexcel.com/how-to-use-excel-vlookup-function-in-office-365/).
- **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.

[![Criteria](https://geekexcel.com/wp-content/uploads/2021/03/Criteria-1.png)](https://geekexcel.com/excel-formula-to-calculate-the-win-loss-points-easy-guide/criteria-16/#main)<figcaption id="caption-attachment-22205">Criteria</figcaption>

- Then apply the above-given formula to the formula bar section and press the **“Enter”** key.

[![Enter the formula](https://geekexcel.com/wp-content/uploads/2021/03/Enter-the-formula-2.png)](https://geekexcel.com/excel-formula-to-calculate-the-win-loss-points-easy-guide/enter-the-formula-64/#main)<figcaption id="caption-attachment-22206">Enter the formula</figcaption>

- Finally, it will display the results in the selected cell.

[![Result](https://geekexcel.com/wp-content/uploads/2021/03/Result-3.png)](https://geekexcel.com/excel-formula-to-calculate-the-win-loss-points-easy-guide/result-195/#main)<figcaption id="caption-attachment-22207">Result</figcaption>

## 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](https://geekexcel.com/) **and [**Excel Formulas**](https://geekexcel.com/excel-formula/) **!!**

### Related Articles:

- **[Excel Formulas to Test If a Cell Value is (X or Y) and Z!!](https://geekexcel.com/excel-formulas-to-test-if-a-cell-value-is-x-or-y-and-z/)**
- **[Excel Formulas to Check If Cell Value is Greater than Given Criteria!!](https://geekexcel.com/excel-formulas-if-cell-value-is-greater-than-given-criteria/)**