Need Excel Formula to complete Function

Discussion in 'Coding' started by MLamb, Aug 18, 2009.

  1. MLamb

    MLamb

    Joined:
    Aug 18, 2009
    Likes Received:
    0
    I have two formulas/functions that I need to run on each cell - the first one is the rank which is working fine...

    =RANK(B13,$B$2:$B$30,0)

    The 2nd function is that I need the cell to be blank if there is nothing in B13. There is another formula that is adding all the rankings up. Currently, putting the ranking formula results in a #N/A in the cell - messing up the entire sheet.

    What am I supposed to put before or after the rank formula to keep the cell blank until something is enterred?

    THANKS!
     
    MLamb, Aug 18, 2009
    #1
    1. Advertisements

  2. MLamb

    Ian Administrator

    Joined:
    Feb 23, 2002
    Likes Received:
    298
    Please only post a thread once, as having two can get confusing :)

    You'll probably need to use the IF conditional, so that if the cell is blank don't run RANK.

    I don't know much Excel, but this might work:

    =IF(B13 = "", " ", RANK(B13,$B$2:$B$30,0))
     
    Ian, Aug 18, 2009
    #2
    1. Advertisements

  3. MLamb

    MLamb

    Joined:
    Aug 18, 2009
    Likes Received:
    0
    Thanks that worked - for some reason on the subsequent cells I had to do " " instead of "" - I have no idea why, but it works.. I appreciate it!
     
    MLamb, Aug 20, 2009
    #3
    1. Advertisements

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. sathish202

    Help Me - Excel Formula

    sathish202, Apr 6, 2009, in forum: Coding
    Replies:
    2
    Views:
    840
    sathish202
    Apr 8, 2009
  2. akou
    Replies:
    0
    Views:
    1,118
  3. mgrichards
    Replies:
    1
    Views:
    1,073
    Stoneboysteve
    Nov 30, 2009
  4. Chames
    Replies:
    1
    Views:
    801
  5. ctallen23
    Replies:
    0
    Views:
    857
    ctallen23
    May 18, 2011
  6. suetteng
    Replies:
    1
    Views:
    745
    sirluke34
    Jan 16, 2012
  7. pompeymick
    Replies:
    7
    Views:
    1,012
    pompeymick
    Mar 21, 2012
  8. Dharani Suresh
    Replies:
    1
    Views:
    2,429
    Sifou
    Nov 12, 2013
Loading...