Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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
![]() |
|||
|
|||
![]()
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
|
|||
|
|||
![]()
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
|
|||
|
|||
![]()
= 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 | |
|
|
![]() |
||||
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 |