How to Calculate Win-Loss Percentage in Excel (with Easy Steps)

Get FREE Advanced Excel Exercises with Solutions!

In general, a rise in the percentage indicates a win, whereas a reduction in the percentage indicates a defeat. In financial analysis, we must determine if a project is in a win or a loss status. In this tutorial, we will show you how to calculate the win-loss percentage in Excel.


How to Calculate Win-Loss Percentage in Excel: 8 Easy Steps

We have supplied a data set reflecting the sales summary for 2 sequential periods in the figure below. We will utilize the data set to calculate the overall win-loss scenario of the transaction. To do this, we will use the IF, COUNTIF, and COUNTA functions.

Sample Data

Step 1: Calculate Percentage of Win-Loss for Each Entry in Excel

  • To calculate the increase or decrease in percentage, firstly type the following formula.
=(D5-C5)/C5

Easy Steps to Calculate Win-Loss Percentage in Excel

  • Press Enter to see the result.

Easy Steps to Calculate Win-Loss Percentage in Excel

  • To convert into a percentage, click on the Percent Style from the Number tab.

Easy Steps to Calculate Win-Loss Percentage in Excel

  • Therefore, the value in cell E5 will show in percentage.

Easy Steps to Calculate Win-Loss Percentage in Excel

  • Apply the same formula in the following rows by using the AutoFill Handle Tool.

Easy Steps to Calculate Win-Loss Percentage in Excel

Read More: Make an Excel Spreadsheet Automatically Calculate Percentage


Step 2: Enter logical_test Argument of IF Function

  • To find the win-loss situation, apply the IF function with the following formula.
=IF(E5>0
  • Enter the logical_test argument as the value of cell E5 has to be positive.

Easy Steps to Calculate Win-Loss Percentage in Excel


Step 3: Insert Value_if_true Argument of IF Function

  • For meeting the condition, enter the value_if_true
  • Type “W” for the value_if_true argument with the following formula. It will show “W” for the positive percentages.
=IF(E5>0,"W",

Easy Steps to Calculate Win-Loss Percentage in Excel


Step 4: Type Value_if_false Argument of IF Function

  • Type “L” for the value_if_false argument with the following formula. It will show “L” for the negative percentages.
=IF(E5>0,"W","L")

Easy Steps to Calculate Win-Loss Percentage in Excel

  • Finally, press Enter and it will appear as “L” as the percentage in cell E5 is negative.

Easy Steps to Calculate Win-Loss Percentage in Excel

  • Then, use the AutoFill Handle Tool to auto-fill the cells.

Easy Steps to Calculate Win-Loss Percentage in Excel


Step 5: Insert COUNTIF Function to Calculate the Number of Win in Win-Loss Percentage in Excel

  • Firstly, to count the total wins in the data set, we will use the COUNTIF function.
  • Select the range F5:F14 as the range argument of the COUNTIF function.
=(COUNTIF(F5:F14

Easy Steps to Calculate Win-Loss Percentage in Excel

  • As we want to count the wins, our criteria argument is “W”.
  • Insert the criteria argument with the following formula.
=(COUNTIF(F5:F14, “W”)

Easy Steps to Calculate Win-Loss Percentage in Excel

  • Press Enter to see the wins. It will result in 4 as the number of wins is 4.

Sample Data


Step 6: Apply COUNTA Function to Calculate the Ratio of Wins

  • Divide the number of wins by the total number by applying the following formula of the COUNTA function.
=(COUNTIF(F5:F14,"W"))/COUNTA(F5:F14)

Sample Data

  • Then, press Enter and see the ratio result in 0.4.

Sample Data


Step 7: Calculate Ratio of Loss

  • Similar to the previous method, apply the same to count the ratio of loss by using the following formula.
=(COUNTIF(F5:F14,"L"))/COUNTA(F5:F14)
  • As a result, it will show as 0.6 for the ratio of loss.

Sample Data


Step 8: Calculate Final Win-Loss Percentage in Excel

  • Finally, to convert the ratios into win-loss percentages, select the cells and click on the Percent Style.
  • Therefore, you will obtain the final win-loss percentage as shown in the image below.

Sample Data


Download Practice Workbook

Download this practice workbook to exercise while you are reading this article.


Conclusion

To conclude, I hope this article has given you some useful information about how to calculate win-loss percentage in Excel. All of these procedures should be learned and applied to your dataset. Take a look at the practice workbook and put these skills to the test. We’re motivated to keep making tutorials like this because of your valuable support.

If you have any questions – Feel free to ask us. Also, feel free to leave comments in the section below.

Stay with us & keep learning.


Related Articles

What is ExcelDemy?

ExcelDemy Learn Excel & Excel Solutions Center provides free Excel tutorials, free support , online Excel training and Excel consultancy services for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Bhubon Costa
Bhubon Costa

Myself, Bhubon Costa, an engineer, is currently employed with Exceldemy as an Excel & VBA Content Developer. I appreciate solving analytical difficulties, finding practical answers, and, for the most part, I enjoy taking on new tasks. I write articles on Exceldemy about various ways to get out of Microsoft Excel's stuck conditions. My passion is to leave my mark on the world through my work and to have an impact on the community who benefit from it.

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo