Calculating Winning Percentages

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

seme - 24 Jun 2004 21:53 GMT

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

--
Message posted from http://www.ExcelForum.com

Reply to this Message

JE McGimpsey - 24 Jun 2004 22:26 GMT

One way:

=A1/(A1 + B1)

Format as percent.

> Hello All,
>
[quoted text clipped - 16 lines]
> ---
> Message posted from http://www.ExcelForum.com/

Reply to this Message

Bill Kuunders - 24 Jun 2004 22:30 GMT

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

> Hello All,
>
[quoted text clipped - 16 lines]
> ---
> Message posted from http://www.ExcelForum.com/

Reply to this Message

CLR - 25 Jun 2004 01:57 GMT

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

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

Vaya con Dios,
Chuck, CABGx3

> Hello All,
>
[quoted text clipped - 16 lines]
> ---
> Message posted from http://www.ExcelForum.com/

Reply to this Message

Dave Peterson - 25 Jun 2004 03:02 GMT

And if you had ties in C:

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

> Hello All,
>
[quoted text clipped - 16 lines]
> ---
> Message posted from http://www.ExcelForum.com/

Signature

Dave Peterson
ec35720@msn.com

Reply to this Message