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:
    670
    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?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.
Similar Threads
  1. sathish202

    Help Me - Excel Formula

    sathish202, Apr 6, 2009, in forum: Coding
    Replies:
    2
    Views:
    901
    sathish202
    Apr 8, 2009
  2. akou
    Replies:
    0
    Views:
    1,302
  3. mgrichards
    Replies:
    1
    Views:
    1,145
    Stoneboysteve
    Nov 30, 2009
  4. Chames
    Replies:
    1
    Views:
    922
  5. ctallen23
    Replies:
    0
    Views:
    941
    ctallen23
    May 18, 2011
  6. suetteng
    Replies:
    1
    Views:
    793
    sirluke34
    Jan 16, 2012
  7. pompeymick
    Replies:
    7
    Views:
    1,201
    pompeymick
    Mar 21, 2012
  8. Dharani Suresh
    Replies:
    1
    Views:
    2,530
    Sifou
    Nov 12, 2013
Loading...