Using the IF and IFBLANK functions

[Superjase14]

Hi there

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

I have a series of sites which have four columns of data with numerica
values in them, but not all schools have data for all of the columns.
therefore want to add a 5th column titled 'Data Quality' which looks a
whether there is data in one or more of the 4 columns. e.g. If there i
data in one column the comment would be 'Poor', data in two column
would be 'average', data in three columns would be 'good' and data i
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,
Jaso

 

[Claus Busch]

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

 

[Mazzaropi]

Hi there
I am trying to get a cell to look at four other cells and provide
comment based on whether there is data in the other four cells or not..
I'm guessing I would use the IF and IFBLANK functions?
I have a series of sites which have four columns of data with numerica
values in them, but not all schools have data for all of the columns.
therefore want to add a 5th column titled 'Data Quality' which looks a
whether there is data in one or more of the 4 columns. e.g. If there i
data in one column the comment would be 'Poor', data in two column
would be 'average', data in three columns would be 'good' and data i
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

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

 

[Superjase14]

Hi

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

Jaso