Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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'm 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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Using the IF and IFBLANK functions
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","Exce llent") Regards Claus Busch -- Win XP PRof SP2 / Vista Ultimate SP2 Office 2003 SP2 /2007 Ultimate SP2 |
#3
|
|||
|
|||
Quote:
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.
__________________
I hope it can help you. Best regards, Marcilio Lobão --------------------------- Belo Horizonte, Brazil |
#4
|
|||
|
|||
Hi
Thanks very much to both of you, both of the formulas you suggested worked so I am very grateful! Jason |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
IFBLANK | Excel Discussion (Misc queries) | |||
within my existing code, check for blank cells in certain rows. Ifblank, exit sub | Excel Programming | |||
ifblank function | Excel Worksheet Functions | |||
Help IfBlank use data from next cell | Excel Worksheet Functions | |||
IFBlank Formula | Excel Programming |