ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   creating a formula for racing (https://www.excelbanter.com/excel-worksheet-functions/157930-creating-formula-racing.html)

Simcoe

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




All times are GMT +1. The time now is 10:44 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com