Hello-
I have aproject that requires me to identify a row into one of four buckets. I made a simplified version of what I am trying to accomplish and attached it as an Excel 2003 workbook.
I tried using the =IF(COUNTIF( statement but since I do not have an array for a range it wouldn’t work
I tried using the IF(OR(AND( but couldn’t get all the conditions to me met
Bucket 1 Criteria
Cust 1 and or Cust 2 have a value, status is not equal to PF and Data 1, 3 and 5 can be empty
Can someone suggest a statement to use since I cannot count the data colomn usuing a COUNT statement since they are not in a contiguous range.
Thank you
If Status is PF then Cust 1 or Cust 2 is not a condition to be met to catagorize what bucket the values get placed under
If Cust 1 and or Cust 2 are blank and status is blank and Data 1, 3 and 5 have values under or equal to 5
Data 1, 3 and 5 must have values equal to or less than 5
Bucket 2 Criteria
If Cust 1 or Cust 2 are blank and there are no blank values in Data 1, 3 and 5 and one of the values is greater than 5 but less than or equal to 9
If there is a value in Cust 1 and or Cust 2 but Status is PF and there is data in Data 1, 3, and 5 and one of the values is greater than 5 but less than or equal to 9
If just one cell in Data 1, 3, and 5 is greater than 5 but less than or equal to 9
Bucket 3 Criteria
If Cust 1 or Cust 2 are blank and there are no blank values in Data 1, 3 and 5 and one of the values is greater than 9
If there is a value in Cust 1 and or Cust 2 but Status is PF and there is data in Data 1, 3, and 5 and one of the values is greater than 9
If just one cell in Data 1, 3, and 5 is greater than 9
Bucket 4 Criteria
There is no value in Cust 1 and or Cust 2 and there is a missing value in Data, 1 or Data 3 or Data 5
There is no values in Cust 1and or Cust 2 and no values in Data 1, 3, and 5
Bookmarks