View Single Post
  #2  
Old 12th October 2005, 12:39 PM
La Mer La Mer is offline
Member
 
Join Date: Jan 1970
Posts: 578
Default

Quote:
Originally Posted by BORDI
hey pplz

just wondering if anyone understands and knows how to use excel.

what i want to do is create a column, eg. DIST, and under that column set up a formula that by putting in data calculates percentages and places a rating along side each percentage. for example. if iwas to calculate for distance id have say at a certain distance 10 starts for 5 wins, i want to be able to enter 5/10 and have the computer work out its 50% and referring to another table 50% = 4 points.

if anyone can help it would be mostly appreciated.

cheers,
matt...


You need to use lookup tables, the Excel help option should give you an idea of exactly how they should be formatted.
Reply With Quote