PC Review


Reply
Thread Tools Rate Thread

Re: Using the IF and IFBLANK functions

 
 
Claus Busch
Guest
Posts: n/a
 
      1st May 2012
Hi Jason,

Am Tue, 1 May 2012 06:25:53 +0000 schrieb Superjase14:

> Site 1 52 89 84 89 Excellent
> Site 2 52 52 Average
> Site 3 18 58 52 Good


your values begin in A2, then try:
=CHOOSE(COUNT(B2:E2),"Poor","Average","Good","Excellent")


Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2
 
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
within my existing code, check for blank cells in certain rows. Ifblank, exit sub ipisors Microsoft Excel Programming 1 7th May 2009 11:21 PM
ifblank function jones.derek@jdirving.com Microsoft Excel Worksheet Functions 5 4th May 2009 05:51 PM
Help IfBlank use data from next cell quzie Microsoft Excel Worksheet Functions 9 2nd May 2009 06:47 PM
if function and ifblank() function Bob Phillips Microsoft Excel Worksheet Functions 3 25th Sep 2006 09:47 PM
IFBlank Formula aldricla Microsoft Excel Programming 3 30th Sep 2004 02:58 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 11:15 PM.