27th April 2005, 05:42 PM
|
|
Member
|
|
Join Date: Jan 1970
Posts: 4,415
|
|
Quote:
|
Originally Posted by Benny
I'm going to use excel to help with my class and weight ratings. My problem is working out the formula for the following.
CLASS RATING-BEATEN MARGIN+WEIGHT=RATING
The headings for my spreadsheet are:
Name of Horse...Jockey...Class Rating...Beaten Margin...Weight...Rating.
Love Street......J. Bloggs....56.................4.9................56 .5....
Benny
|
If your headings are in row 1 and your data starts in row 2.....
In cell F2 (your rating column) type in =(C2-D2)+E2
Copy this cell and paste it all the way down the column, as far as you have data.
HTH. |