View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Frank & Pam Hayes[_2_] Frank & Pam Hayes[_2_] is offline
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/