PC Review


Reply
Thread Tools Rate Thread

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!
 
Reply With Quote
 
 
 
 
Ian Ian is offline
Rocket Scientist
Ian's Avatar
Join Date: Feb 2002
Location: Manchester, UK
Posts: 16,873
 
      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))
 
Reply With Quote
 
 
 
 
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!
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

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 Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Vista Complete Backup - First Complete Backup Tim Windows Vista General Discussion 6 15th Mar 2008 07:13 PM
how do I get Word to auto complete the complete date? Microsoft Word New Users 8 25th Sep 2007 02:26 PM
Automatic complete on cursor location (hover complete??) =?Utf-8?B?ZXBw?= Windows XP Basics 0 26th Feb 2006 02:27 PM
Page Not Complete In I.E. - Is Complete In Firefox and Netscape Dick Microsoft Frontpage 15 20th May 2005 05:44 AM
SP2 Download Complete or Not Complete geof Windows XP General 3 2nd Sep 2004 03:42 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 09:43 AM.