+ Reply to Thread
Results 1 to 3 of 3

Online Racing Championship spreadsheet-changing points to positions

  1. #1
    Registered User
    Join Date
    02-26-2017
    Location
    Darlington, England
    MS-Off Ver
    2010
    Posts
    2

    Exclamation Online Racing Championship spreadsheet-changing points to positions

    Hello all,

    I host an Online F1 Championship every weekend, and I currently log all of the race results and points totals in a spreadsheet.

    Here is an image; http://imgur.com/Bl0PwBh

    Basically, on the right hand side you will see a Positions/Points table (1st = 25, 2nd = 18 etc) and what I do, is I put in 25 for the race winner, next to their name on the relevant race they won. I want to be able to change this so I can put in everyone's positions instead of points (1st instead of 25 etc) but then the totals on the right hand side to add 25, or add 18 depending on the position I put in the cell. Is this possible?

    I tried "=IF(A3<1>""AA3+25)" but had no luck.

  2. #2
    Forum Expert
    Join Date
    11-22-2016
    Location
    Cornwall,UK
    MS-Off Ver
    office 365
    Posts
    4,240

    Re: Online Racing Championship spreadsheet-changing points to positions

    welcome to the forum

    One way is to use vLookUp.
    Look up (in a table) the value of the position in the race and tell me how many points that equates to.

    see attached workbook ( I have invented the attributable points per position)

    Please Login or Register  to view this content.
    where:
    E2 is the position in race
    "Points" is named range A2:B11
    2 - we want the value from the second column in the table (not because it is column B)
    0 - we want exact match


    F1.jpg
    Attached Files Attached Files
    Click *Add Reputation to thank those who helped you. Ask if anything is not clear

  3. #3
    Forum Expert
    Join Date
    11-22-2016
    Location
    Cornwall,UK
    MS-Off Ver
    office 365
    Posts
    4,240

    Re: Online Racing Championship spreadsheet-changing points to positions

    and another way - this time using
    Formula: copy to clipboard
    Please Login or Register  to view this content.


    F1 Indirect.jpg
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 2
    Last Post: 04-27-2015, 12:22 PM
  2. [SOLVED] Rank with changing positions
    By jharaldson in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-15-2013, 01:45 PM
  3. Replies: 4
    Last Post: 07-07-2013, 02:50 PM
  4. [SOLVED] Calculating League points for multiple tied positions (Excel 2010)
    By Sage013 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-01-2013, 07:48 PM
  5. formula to allocate points to positions in a race
    By SEVKN in forum Excel General
    Replies: 2
    Last Post: 10-14-2008, 02:52 AM
  6. Daily Racing Form: Horse racing
    By mehtalmann in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 08-11-2006, 04:40 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1