+ Reply to Thread
Results 1 to 5 of 5

If Statement, or am I going about this wrong?

Hybrid View

  1. #1
    Registered User
    Join Date
    10-09-2008
    Location
    rhode island
    Posts
    3
    Ok, so at the beginning it was what I am looking for, however, the part I completely forgot about was the points awarded are a variable to a max, there will be no more than 60 pts awarded to the winner, so 30 competitors is considered a "full" field. Well, more than 30 competitors can start, so is there a way to use a less than in the formula, to where find max under 31?

    Thanks again

    John Andrade' III
    [email protected]

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,467
    You will now need to know the size of the Competitor's being scored.
    This is for 30 finishing scores. reset get 0

    =IF((MIN(MAX($J$2:$J$51),30)*2)-((J2-1)*2)<2,0,(MIN(MAX($J$2:$J$51),30)*2)-((J2-1)*2))
    Cheers
    Andy
    www.andypope.info

+ 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. 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