+ Reply to Thread
Results 1 to 6 of 6

Shortening a long formula

  1. #1
    Forum Contributor Marvo's Avatar
    Join Date
    01-15-2009
    Location
    Northampton, England
    MS-Off Ver
    Excel 2021
    Posts
    990

    Red face Shortening a long formula

    I have a formula that basically awards 10 points to the person finishing 1st, 9 points 2nd and so on down to 10th.

    =IF(Unofficial!G4=1,10,(IF(Unofficial!G4=2,9,(IF(Unofficial!G4=3,8,(IF(Unofficial!G4=4,7,(IF(Unofficial!G4=5,6,(IF(Unofficial!G4=6,5,(IF(Unofficial!G4=7,4,(IF(Unofficial!G4=8,3,(IF(Unofficial!G4=9,2,(IF(Unofficial!G4=10,1,)))))))))))))))))))

    This works but I'm wondering if I can achieve the same result with a shorter more concise formula.

    Any help much obliged, even if its only to say "stick with what you've got".
    Last edited by Marvo; 06-22-2019 at 01:54 PM.

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,721

    Re: Shortening a long formula

    How about

    =11-Unofficial!G4
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

  3. #3
    Forum Contributor Marvo's Avatar
    Join Date
    01-15-2009
    Location
    Northampton, England
    MS-Off Ver
    Excel 2021
    Posts
    990

    Re: Shortening a long formula

    Jeez, how stupid am I? Thanks very much, I was coming at that all the wrong way.

  4. #4
    Forum Expert
    Join Date
    09-01-2012
    Location
    Norway
    MS-Off Ver
    Office 365
    Posts
    2,844

    Re: Shortening a long formula

    On the other hand you created a quite a few smiles around the planet with this thread, not a bad thing.
    <----- If you were helped by my posts you can say "Thank you" by clicking the star symbol down to the left

    If the problem is solved, finish of the thread by clicking SOLVED under Thread Tools
    I don't wish to leave you with no answer, yet I sometimes miss posts. If you feel I forgot you, remind me with a PM or just bump the thread.

  5. #5
    Forum Contributor Marvo's Avatar
    Join Date
    01-15-2009
    Location
    Northampton, England
    MS-Off Ver
    Excel 2021
    Posts
    990

    Re: Shortening a long formula

    True. I did have to lengthen it a bit as I didn't want a return of 11 showing before a game was played but that was relatively simple. Thanks again.

  6. #6
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,721

    Re: Shortening a long formula

    Quote Originally Posted by Marvo View Post
    Jeez, how stupid am I? Thanks very much, I was coming at that all the wrong way.
    Not at all! The smartest thing to come here with a good question clearly stated!

+ 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. [SOLVED] Shortening a long formula of a series of Sum(If statements
    By JimDandy in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 10-25-2017, 12:42 PM
  2. [SOLVED] Shortening a long line of text
    By nrgaust in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 06-07-2016, 03:17 AM
  3. Shortening of VERY LONG UserForm VBA Code
    By PDBartlett in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 04-14-2014, 06:55 AM
  4. Shortening of long array formula by short formula
    By paradise2sr in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-29-2013, 05:51 AM
  5. [SOLVED] Macro line too long, needs shortening?
    By Hyflex in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-09-2011, 01:46 PM
  6. Shortening long IF statement?
    By Lukus in forum Excel General
    Replies: 1
    Last Post: 12-21-2009, 05:44 PM
  7. Shortening a formula
    By GTVT06 in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 07-19-2006, 09:50 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