How to Calculate Win Percentage in Excel


Win percentage is a metric that tells you the percentage of games or matches that some team wins.

It is calculated as:

Win Percentage = Wins / (Wins + Losses)

For example, if a team wins 40 games and loses 10 games, then their win percentage is calculated as:

  • Win Percentage = Wins / (Wins + Losses)
  • Win Percentage = 40 / (40 + 10)
  • Win Percentage = 40 / 50
  • Win Percentage = 80%

The following example shows how to calculate win percentage in Excel.

Example: How to Calculate Win Percentage in Excel

Suppose we have the following dataset in Excel that shows the number of games won and lost by various basketball teams:

Suppose we would like to calculate the win percentage for each team.

To do so, we can type the following formula into cell D2:

=B2/(B2+C2)

We can then click and drag this value down to each remaining cell in column D:

Lastly, highlight the range D2:D11 and then click the Number Format dropdown menu in the Number group on the Home tab and click Percentage:

The values in column D will now be formatted as percentages:

Column D shows the win percentage for each team.

For example:

  • The Mavs won 51.22% of their total games.
  • The Spurs won 60.98% of their total games.
  • The Rockets won 74.39% of their total games.

And so on.

Additional Resources

The following tutorials explain how to perform other common operations in Excel:

How to Calculate Accuracy Percentage in Excel
How to Calculate Reverse Percentage in Excel
How to Convert Percentage to Ratio in Excel

Leave a Reply

Your email address will not be published. Required fields are marked *