hey davez

thanx. what i mean is.. say we are looking at distance. if a race is 1600m and a horse has run it 10 times for 5 wins the ratio would be 50% win rate over that dist. wat i have done is say 40-59% = 4 points, 60+% = 5points etc. what i want ot be able to do is enter into the colum named distance the value 5/10 where the spreadsheet should work out the percentage and assign the relevant points which it can derive from another table in the spreadsheet.