A spreadsheet moron looking for help.


  1. gtitus
    Posts : 4
    Windows 7 Professional
       New #1

    A spreadsheet moron looking for help.


    What is the formula that will calculate the percentage of random cells?
    Last edited by gtitus; 20 Jan 2011 at 19:40.
      My Computer
    Quote Quote

  3. DeVandal
    Posts : 287
    Windows 7 Ultimate x64
       New #2

    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 Computer
    Quote Quote

  4. gtitus
    Posts : 4
    Windows 7 Professional
    Thread Starter
       New #3

    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 Computer
    Quote Quote

 

  Related Discussions
works spreadsheet
in Microsoft Office

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...
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...
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...
Spreadsheet
in Microsoft Office

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...
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...
Our Sites
Site Links
About 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 03:17.
Find Us