Calculating Winning Percentages
 

Hello All,

Can someone help with a formula for winning percentage?

Example

Cell A = 10 (Wins)
Cell B = 4 (Losses) (Need to get a Winning Percentage for thos
numbers.


I'm a beginner with excel, so any help would be greatly appreciated.


Thanks in advance!!!

Sem

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

Answer: Calculating Winning Percentages
 

Calculating Winning Percentage in Excel

Calculating winning percentage in Excel is actually quite simple. You just need to divide the number of wins by the total number of games played (wins + losses).

Here's the formula you can use:

Assuming your wins are in cell A1 and losses are in cell B1, you can enter this formula in another cell (let's say C1) and it will give you the winning percentage.

For your example, the formula would be:

This would give you a winning percentage of 0.714 or 71.4%.

1. Divide the number of wins by the total number of games played (wins + losses).
2. Use the formula:
   Formula:

   ---

   = A1 / (A1 + B1) 


   ---

3. Enter the formula in another cell (let's say C1) to get the winning percentage.
4. For example, use the formula
   Formula:

   ---

   = 10 / (10 + 4) 


   ---

   to get a winning percentage of 0.714 or 71.4%.

Calculating Winning Percentages
 

Assume Cell A1 = 10 (number of Wins)
Assume Cell B1 = 4 (number of Losses
in Cell C1 type everything between these quotes ... "=A1/(A1+B1)"
then format C1 as a percentage using the % toolbar at the top.

This will give you the percentage of wins of total trials.

Good luck

Frank

"seme " wrote in message
...
Hello All,

Can someone help with a formula for winning percentage?

Example

Cell A = 10 (Wins)
Cell B = 4 (Losses) (Need to get a Winning Percentage for those
numbers.


I'm a beginner with excel, so any help would be greatly appreciated.


Thanks in advance!!!

Seme


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

Calculating Winning Percentages
 

= CellA / (CellA+CellB)

John Michl

"seme " wrote in message
...
Hello All,

Can someone help with a formula for winning percentage?

Example

Cell A = 10 (Wins)
Cell B = 4 (Losses) (Need to get a Winning Percentage for those
numbers.


I'm a beginner with excel, so any help would be greatly appreciated.


Thanks in advance!!!

Seme


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