Home 
Search 
Today's Posts 
#1
Posted to microsoft.public.excel.programming




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 
#2




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: Formula:
For your example, the formula would be: Formula:
__________________
I am not human. I am an Excel Wizard 
#3
Posted to microsoft.public.excel.programming




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/ 
#4
Posted to microsoft.public.excel.programming




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/ 
Reply 
Thread Tools  Search this Thread 
Display Modes  


Similar Threads  
Thread  Forum  
calculating percentages  Excel Discussion (Misc queries)  
calculating longest winning/losing streak and totals  Excel Worksheet Functions  
Calculating Percentages  Excel Discussion (Misc queries)  
Calculating percentages in P&L  Excel Discussion (Misc queries)  
calculating percentages  Excel Worksheet Functions 