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