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



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 12: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 04:06 PM.

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

About Us

"It's about Microsoft Excel"