Windows 7 Forums

Welcome to Windows 7 Forums. Our forum is dedicated to helping you find support and solutions for any problems regarding your Windows 7 PC be it Dell, HP, Acer, Asus or a custom build. We also provide an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.


Windows 7: A spreadsheet moron looking for help.

20 Jan 2011   #1
gtitus

Windows 7 Professional
 
 
A spreadsheet moron looking for help.

What is the formula that will calculate the percentage of random cells?


My System SpecsSystem Spec
.

20 Jan 2011   #2
DeVandal

Windows 7 Ultimate x64
 
 

insufficient (or poorly presented) data.

Win% is Wins/GamesPlayed
or
Win% =cell [Total Wins]/cell [Total Games Played]

It is not necessary to show colmns/rows that sum total games and/or wins, but it is MUCH easier (in a spreadsheet) to sum these values for use in a formula reference.
My System SpecsSystem Spec
20 Jan 2011   #3
gtitus

Windows 7 Professional
 
 

I agree about the poorly prensented data. I have labored for several minutes to get it into a readable format but, appearently, I can't.

I can't thank you enough for your time and effort. Thanks DeVandal
My System SpecsSystem Spec
.


Reply

 A spreadsheet moron looking for help.




Thread Tools





Similar help and support threads
Thread Forum
works spreadsheet
Starting a few months ago any spreadsheet I created in Microsoft Works would develop the "hiccups". The spread sheet would create and you could post entries but only between the fluctuations of the "hourglass" icon cycling about every 2 seconds. I would resolve this by restoring to an earlier...
Microsoft Office
A lot of ##### in my spreadsheet.
I have decided to download my bank account monthly balance sheet,Got it into a spreadsheet okay But the last column with the total balance I get a lot of these ########. With no figures. Example 100.00 I get ####### How can I solve this please,The other column's with input's show the figures...
Microsoft Office
Help. I'm a moron, so I deleted the SP1 Beta uninstall files.
Uh, so, yeah. Windows helpfully gives me a message, every-so-often, stating that it will expire in 0 hours, as I have a beta version of SP 1. Obviously, the solution is to use the non-beta version of SP 1, however, I can't do that, because I accidentally deleted the un-install files, using...
Installation & Setup
Spreadsheet
Hello.Just installed Open Office,Now trying to use the spreadsheet system. I thought that I would make an address book up of family names etc,Now when it comes to entering their telephone ie:01683***** when its in the column the nought aint there can anyone explain to me why this is and is there a...
Microsoft Office
Opening a spreadsheet
I get a monthly listing in my email that comes as a spreadsheet. When I try to open it, I get the message that I do not have Windows Office 2010 installed and it gives me options to purchase,etc. I have another spreadsheet installed on my computer and would prefer to use it but I don't know how to...
Software

Our Sites

Site Links

About Us

Find Us

Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

Designer Media Ltd

All times are GMT -5. The time now is 18:30.

Twitter Facebook Google+



Windows 7 Forums

Seven Forums Android App Seven Forums IOS App