Hi all, a newbie to forum so here goes.
I am trying to build a sheet that allows me to manage a race concept.
Runners run a distance but guess their time; the nearer they get to this time the more points they receive.
In the example 4 runners have posted a time they think they can run a mile (Col D). Columns B and C are for their time less 10 and 20% respectively and Columns E and F are same for time plus 10 and 20%.
Their actual time is in Column G.
I want Column H automatically fill the points from this simple table;
Exact time = 25pts
Within 10% = 20pts
Within 20% = 15pts
Anything over 21% = 10pts
I have attached a screen shot from my numbers page on iPad to show concept.
IMG_0175.PNG
Bookmarks