# Need Excel Formula to complete Function

New Member
Join Date: Aug 2009
Posts: 2

 18th Aug 2009
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!

Rocket Scientist
Join Date: Feb 2002
Location: Manchester, UK
Posts: 16,850

 18th Aug 2009
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))

New Member
Join Date: Aug 2009
Posts: 2

 20th Aug 2009
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!

 Thread Tools Rate This Thread Rate This Thread: 5 : Excellent 4 : Good 3 : Average 2 : Bad 1 : Terrible

 Posting Rules You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are Off Forum Rules

 Similar Threads Thread Thread Starter Forum Replies Last Post Tim Windows Vista General Discussion 6 15th Mar 2008 07:13 PM Microsoft Word New Users 8 25th Sep 2007 02:26 PM =?Utf-8?B?ZXBw?= Windows XP Basics 0 26th Feb 2006 02:27 PM Dick Microsoft Frontpage 15 20th May 2005 05:44 AM geof Windows XP General 3 2nd Sep 2004 03:42 AM

Features