# 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. ### 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` • Press Enter to see the result. • To convert into a percentage, click on the Percent Style from the Number tab. • Therefore, the value in cell E5 will show in percentage. • Apply the same formula in the following rows by using the AutoFill Handle Tool. ### 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. ### 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",` ### 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")` • Finally, press Enter and it will appear as “L” as the percentage in cell E5 is negative. • Then, use the AutoFill Handle Tool to auto-fill the cells. ### 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` • As we want to count the wins, our criteria argument is “W”.
• Insert the criteria argument with the following formula.
`=(COUNTIF(F5:F14, “W”)` • Press Enter to see the wins. It will result in 4 as the number of wins is 4. ### 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)` • Then, press Enter and see the ratio result in 0.4. ### 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. ### 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. ## 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.

## 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

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 Advanced Excel Exercises with Solutions PDF  