Excel - Using the IF and IFBLANK functions

Hi there

I am trying to get a cell to look at four other cells and provide a
comment based on whether there is data in the other four cells or not...
I am guessing I would use the IF and IFBLANK functions?

I have a series of sites which have four columns of data with numerical
values in them, but not all schools have data for all of the columns. I
therefore want to add a 5th column titled 'Data Quality' which looks at
whether there is data in one or more of the 4 columns. e.g. If there is
data in one column the comment would be 'Poor', data in two columns
would be 'average', data in three columns would be 'good' and data in
all columns would be 'excellent'. It would look something like this...
Data Quality
Site 1   52    89    84    89   Excellent
Site 2          52    52          Average
Site 3   18    58           52   Good

Is there any way to do this in Excel?

Thanks very much,
Jason




--
Superjase14

Hi Jason,

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


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

Superjase14;1601341 Wrote:


Dear *Jason*, Good Morning.

Try to use this formula at *Data Quality* column.

=LOOKUP(COUNTA(B2:E2),{1.2.3.4},{\"POOR\".\"AVERAGE\".\"GOOD\".\"EXCELLENT\"})

Adapt the range B2:E2 to your real case at worksheet.

Tell me if it worked for you.
I´ll be here for some time.




--
Mazzaropi

Hi

Thanks very much to both of you, both of the formulas you suggested
worked so I am very grateful!

Jason




--
Superjase14