Calculating Winning Percentages

[seme]

Hello All,

Could someone help me with a formula for winning percentages?

Example:

Cell A 10 (Wins)

Cell B 4 (Losses)

I'm trying to get the winning percentage of those 2 numbers.


Any help would be greatly appreciated!!!

Thanks in advance...

Sem

 

[JE McGimpsey]

One way:

=A1/(A1 + B1)

Format as percent.

 

[Bill Kuunders]

Say cell a1 = 10
cell a2 = 4
cell a3 = sum(a1:a2)

in cell a4 enter = 100*a1/a3 to represent the number of wins as a
percentage of the total number of games played

Regards
Bill K

 

[CLR]

With wins in A1 and losses in B1, put this in C1

="Win percentage = "&(A1/(A1 + B1))*100&"%"


Vaya con Dios,
Chuck, CABGx3

 

[Dave Peterson]

And if you had ties in C:

=(a1+c1/2)/(a1+b1+c1)