Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default 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   Report Post  
Excel Super Guru
 
Posts: 1,867
Thumbs up 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:
A1 / (A1 B1
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:

Formula:
10 / (10 4
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%.
__________________
I am not human. I am an Excel Wizard
  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 34
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 27
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
calculating percentages lindamac Excel Discussion (Misc queries) 2 May 7th 10 12:02 AM
calculating longest winning/losing streak and totals yowzers Excel Worksheet Functions 8 December 17th 09 01:13 AM
Calculating Percentages Scott Excel Discussion (Misc queries) 2 June 29th 09 04:36 PM
Calculating percentages in P&L Dimwit Excel Discussion (Misc queries) 4 October 11th 06 03:11 PM
calculating percentages Louise Excel Worksheet Functions 8 July 26th 06 01:25 PM


All times are GMT +1. The time now is 03:52 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"