Calculating Winning Percentages

  • Thread starter Thread starter seme
  • Start date Start date
S

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
 
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
 
With wins in A1 and losses in B1, put this in C1

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


Vaya con Dios,
Chuck, CABGx3
 
Back
Top