![Old](images/statusicon/post_old.gif)
12th October 2005, 12:39 PM
|
Member
|
|
Join Date: Jan 1970
Posts: 578
|
|
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.
|