Need Excel Formula to complete Function

Discussion in 'Webmaster / Programming' started by MLamb, Aug 18, 2009.

  1. MLamb

    MLamb

    Joined:
    Aug 18, 2009
    Messages:
    2
    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
    Messages:
    16,914
    Likes Received:
    95
    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
    Messages:
    2
    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: Webmaster / Programming
    Replies:
    2
    Views:
    757
    sathish202
    Apr 8, 2009
  2. mgrichards

    Can you make this 2007 Excel formula work in 2003 version?

    mgrichards, Nov 30, 2009, in forum: Webmaster / Programming
    Replies:
    1
    Views:
    929
    Stoneboysteve
    Nov 30, 2009
  3. ctallen23

    Need help with basic covariance function

    ctallen23, May 18, 2011, in forum: Webmaster / Programming
    Replies:
    0
    Views:
    768
    ctallen23
    May 18, 2011
  4. suetteng

    Write a formula function for different senarios

    suetteng, Oct 15, 2011, in forum: Webmaster / Programming
    Replies:
    1
    Views:
    675
    sirluke34
    Jan 16, 2012
  5. Dharani Suresh

    Vb macro coding for transpose - complete coding?

    Dharani Suresh, Jul 31, 2013, in forum: Webmaster / Programming
    Replies:
    1
    Views:
    2,295
    Sifou
    Nov 12, 2013
Loading...

Share This Page