Results 1 to 5 of 5

If Statement, or am I going about this wrong?

Threaded View

  1. #1
    Registered User
    Join Date
    10-09-2008
    Location
    rhode island
    Posts
    3

    If Statement, or am I going about this wrong?

    I've been working on this project for racing, where the points are calculated by the finishing order of the competitors. However the points are variable based on the # of competitors running in the event.

    Ex.

    30 competitors run, winner gets 60, then descends by 2 down to 30th place.
    25 competitors run, winner gets 50, then descends by 2 down to 25th place.

    So total # of competitors multiplied by 2 gives you the winner's point total.

    My question is if there is a formula to determine, if the finishing order spot for competitor A shows 1 it finds the highest number(max formula) in the row, multiple by 2; however, if it does not show one, it needs to be able to calculate accordingly, so if it shows a 2, find max, multiply by 2, then subtract 2, or if it shows a 5, find max, multiply by 2, then subtract 8, etc down to 30. I've tried a nested if statement, but it certainly won't allow 29 nests in it. Is there any other formula I may have overlooked?

    I appreciate any help that can be given.

    John Andrade' III
    [email protected]
    Last edited by JJAndradeIII; 10-10-2008 at 02:17 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. nested IF statement
    By Steelhead in forum Excel General
    Replies: 6
    Last Post: 10-02-2008, 01:03 PM
  2. If Statement in 'For' Statement - What's wrong?
    By dugong in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-16-2008, 12:22 PM
  3. What is wrong with this If statement?
    By shaolin in forum Excel General
    Replies: 3
    Last Post: 01-30-2008, 01:11 PM
  4. With Statement Questions
    By OzTrekker in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-02-2007, 02:44 AM
  5. advanced (i think) if statement help
    By ukrockhit in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 11-06-2006, 11:41 AM

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