# How to Calculate the Win-Loss Percentage in Excel – 8 Easy Steps

The dataset showcases the sales summary of 2 sequential periods.

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

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

• Press Enter to see the result.

• To convert the result into a percentage, click Percent Style in Number.

The value in E5 is displayed in percentage.

• Drag down the Fill Handle to see the result in the rest of the cells.

### Step 2 – Enter a logical_test Argument with the IF Function

• Use the IF function with the following formula.
`=IF(E5>0`
• Enter the logical_test argument: the value of E5 has to be positive.

### Step 3 – Insert the Value_if_true Argument in the IF Function

• Use value_if_true.
• Enter “W” for the value_if_true argument with the following formula. (“W”  will be displayed for positive percentages)
`=IF(E5>0,"W",`

### Step 4 – Enter the Value_if_false Argument in the IF Function

• Enter “L” for the value_if_false argument. Use the following formula. It will show (“L” will be displayed for negative percentages)
`=IF(E5>0,"W","L")`

• Press Enter.

L” is displayed in E5, as the percentage is negative.

• Drag down the Fill Handle to see the result in the rest of the cells.

### Step 5 – Insert the COUNTIF Function to Calculate the Number of Wins in the Win-Loss Percentage

To count the total wins:

• Select F5:F14 as the range argument of the COUNTIF function.
`=(COUNTIF(F5:F14`

• The criteria argument is “W”.
• Enter the criteria argument in the following formula.
`=(COUNTIF(F5:F14, “W”)`

• Press Enter to see the wins.

4 is the number of wins.

### Step 6 – Apply the COUNTA Function to Calculate the Ratio of Wins

• Enter the following formula.
`=(COUNTIF(F5:F14,"W"))/COUNTA(F5:F14)`

• Press Enter.

The ratio is 0.4.

### Step 7 – Calculate the Ratio of Loss

• Use the following formula.
`=(COUNTIF(F5:F14,"L"))/COUNTA(F5:F14)`

0.6 is the ratio of loss.

### Step 8 – Calculate the Final Win-Loss Percentage in Excel

• To convert the ratios into win-loss percentages, select the cells and click Percent Style.

This is the output.

## Related Articles

<< Go Back to Calculating Percentages | Calculate in Excel | Learn Excel

Get FREE Advanced Excel Exercises with Solutions!
Bhubon Costa

Bhubon Costa, B.Sc. in Naval Architecture & Marine Engineering from Bangladesh University of Engineering & Technology, has worked with the ExcelDemy since 2021. Currently, he has been working as a reviewer. Notably, he has written over 90 articles and led several VBA content development teams. He has a great passion for the fields of data analytics and data science. His areas of expertise include Excel VBA, Power Query, Pivot Table, Power BI, MySQL, PostgreSQL, machine learning, and Python... Read Full Bio

We will be happy to hear your thoughts

Advanced Excel Exercises with Solutions PDF