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

## 2 Replies to “How to Calculate Win Percentage in Excel”

1. Agada Mathias says:

Thank you so much for this brief but exact tutorial.

1. James Carmichael says:

Hi Agada…You are very welcome! Thank you for your feedback!