<P> In sports, a winning percentage is the fraction of games or matches a team or individual has won . It is defined as wins divided by the total number of matches played (i.e. wins plus draws plus losses). A draw counts as a 1⁄2 win . </P> <P> For example, if a team's season record is 30 wins and 20 losses, the winning percentage would be . 600 . If a team's season record is 30--15--5 (i.e. it has won thirty games, lost fifteen and tied five times), the five tie games are counted as 21⁄2 wins, and so the team has an adjusted record of 321⁄2 wins, resulting in a . 650 winning percentage for the fifty total games from </P> <Dl> <Dd> winning percentage = wins + 0.5 ⋅ ties total games ⋅ 100% (\ displaystyle (\ text (winning percentage)) = ((\ text (wins)) + 0.5 \ cdot (\ text (ties)) \ over (\ text (total games))) \ cdot 100 \%) </Dd> <Dd> 65% = 32.5 50 ⋅ 100% (\ displaystyle 65 \% = (32.5 \ over 50) \ cdot 100 \%) </Dd> </Dl>

How to calculate win percentage with ties in excel