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.

• 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.

Read More: Make an Excel Spreadsheet Automatically Calculate Percentage

Step 2 – Enter a logical_test Argument with the IF Function

• Use the IF function with the following formula.

• 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)

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)

• 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.

• The criteria argument is “W”.
• Enter the criteria argument in the following formula.

• 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.

• Press Enter.

The ratio is 0.4.

Step 7 – Calculate the Ratio of Loss

• Use the following formula.

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.

Download Practice Workbook

Download the practice workbook to exercise.

Related Articles

• How to Calculate Cumulative Percentage in Excel
• How to Calculate SLA Percentage in Excel
• How to Calculate Error Percentage in Excel
• How to Calculate Remaining Shelf Life Percentage in Excel
• How to Calculate Percentage of Completion in Excel
• How to Calculate Percentage of Budget Spent in Excel
• How to Calculate Utilization Percentage in Excel
  
• How to Calculate Absenteeism Percentage in Excel
  
• How to Calculate Savings Percentage in Excel
  
• How to Calculate Productivity Percentage in Excel
• How to Calculate Variance Percentage in Excel
  
• How to Calculate Accuracy Percentage in Excel
• How to Calculate Grade Percentage in Excel

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