Need Excel Formula to complete Function

Joined
Aug 18, 2009
Messages
2
Reaction score
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!
 

Ian

Administrator
Joined
Feb 23, 2002
Messages
19,873
Reaction score
1,499
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))
 
Joined
Aug 18, 2009
Messages
2
Reaction score
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!
 

Ask a Question

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. After that, you can post your question and our members will help you out.

Ask a Question

Top