View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Simcoe Simcoe is offline
external usenet poster
 
Posts: 1
Default creating a formula for racing

I am very new to this I have to set up a program to calculate which allows
it to go into 2 sections as follows:
REsults Heat 1 Heat 2 Feature
John Doe 1 6 20
Mary SMith 4 5 16
Dave jacks 2 3
5
etc, etc

then the points would be as follows:
Standings Heat 1 Heat 2
Feature Total

John Doe 24 10
38 72
Mary Smith 15 12
54 81
Dave Jacks 22 12
60 94
etc
How would I create a program that would allow me to enter the position the
person came in and then it would automatically enter into a different column
the points they would receive for that race and then it would be post would
would be in 1st , 2nd, 3rd, etc place and then post on the internet by each
week by scrolling down the dates results and standings