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 |
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 |