Need Excel Formula to complete Function

M

MLamb

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!
 
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))
 
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!
 
Back
Top