Spreadsheet: 160622d1339144928-more-help-combining-if-forumlas-please-excel-forum-1-
Sheet: Sheet1

 |  |  | formula should go in yellow column |  |  |  | helper column
 |  |  |  |  | Reason | Code
 |  |  |  |  | red
 |  |  |  |  | red
 |  |  |  |  | green
 |  |  |  |  | purple
 |  |  |  |  | blue
 |  |  |  |  | blue
 |  |  |  |  | purple
 |  |  |  |  | purple
 |  |  |  |  | purple
 |  |  |  |  | purple
 |  |  |  |  | purple
 |  |  |  |  | purple
 |  |  |  |  | red
 |  |  |  |  | purple
 |  |  |  |  | purple
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | red
 |  |  |  |  | red
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | red
 |  |  |  |  | not relevant
 |  |  |  |  | red
 |  |  |  |  | not relevant
 |  |  |  |  | blue
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | red
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | green
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | green
 |  |  |  |  | purple
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | blue
 |  |  |  |  | purple
 |  |  |  |  | purple
 |  |  |  |  | purple
 |  |  |  |  | purple
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | red
 |  |  |  |  | purple
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | blue
 |  |  |  |  | red
 |  |  |  |  | purple
 |  |  |  |  | purple
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | blue
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | red
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | red
 |  |  |  |  | purple
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | red
 |  |  |  |  | purple
 |  |  |  |  | purple
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | red
 |  |  |  |  | purple
 |  |  |  |  | purple
 |  |  |  |  | purple
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | green
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | green
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | green
 |  |  |  |  | purple
 |  |  |  |  | not relevant
 |  |  |  |  | green
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | green
 |  |  |  |  | purple
 |  |  |  |  | purple
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | green
 |  |  |  |  | purple
 |  |  |  |  | purple
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | green
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | blue
 |  |  |  |  | blue
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | blue
 |  |  |  |  | purple
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | red
 |  |  |  |  | purple
 |  |  |  |  | purple
 |  |  |  |  | purple
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | green
 |  |  |  |  | purple
 |  |  |  |  | purple
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | green
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | green
 |  |  |  |  | purple
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | green
 |  |  |  |  | purple
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | red
 |  |  |  |  | green
 |  |  |  |  | red
 |  |  |  |  | red
 |  |  |  |  | red
 |  |  |  |  | purple
 |  |  |  |  | purple
 |  |  |  |  | red
 |  |  |  |  | purple
 |  |  |  |  | purple
 |  |  |  |  | red
 |  |  |  |  | purple
 |  |  |  |  | red
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | red
 |  |  |  |  | green
 |  |  |  |  | red
 |  |  |  |  | red
 |  |  |  |  | red
 |  |  |  |  | purple
 |  |  |  |  | not relevant
 |  |  |  |  | red
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | red
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | red
 |  |  |  |  | red
 |  |  |  |  | red
 |  |  |  |  | red
 |  |  |  |  | red
 |  |  |  |  | purple
 |  |  |  |  | purple
 |  |  |  |  | red
 |  |  |  |  | purple
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | blue
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | red
 |  |  |  |  | purple
 |  |  |  |  | purple
 |  |  |  |  | red
 |  |  |  |  | red
 |  |  |  |  | purple
 |  |  |  |  | green
 |  |  |  |  | red
 |  |  |  |  | green
 |  |  |  |  | red
 |  |  |  |  | red
 |  |  |  |  | not relevant
 |  |  |  |  | red
 |  |  |  |  | purple
 |  |  |  |  | not relevant
 |  |  |  |  | green
 |  |  |  |  | red
 |  |  |  |  | red
 |  |  |  |  | green
 |  |  |  |  | green
 |  |  |  |  | green
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | red
 |  |  |  |  | red
 |  |  |  |  | red
 |  |  |  |  | red
 |  |  |  |  | red
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | green
 |  |  |  |  | purple
 |  |  |  |  | red
 |  |  |  |  | purple
 |  |  |  |  | red
 |  |  |  |  | red
 |  |  |  |  | red
 |  |  |  |  | purple
 |  |  |  |  | red
 |  |  |  |  | red
 |  |  |  |  | red
 |  |  |  |  | red
 |  |  |  |  | red
 |  |  |  |  | red
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | red
 |  |  |  |  | red
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | red
 |  |  |  |  | red
 |  |  |  |  | red
 |  |  |  |  | red
 |  |  |  |  | red
 |  |  |  |  | red
 |  |  |  |  | purple
 |  |  |  |  | purple
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | red
 |  |  |  |  | red
 |  |  |  |  | red
 |  |  |  |  | red
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | red
 |  |  |  |  | red
 |  |  |  |  | blue
 |  |  |  |  | blue
 |  |  |  |  | red
 |  |  |  |  | red
 |  |  |  |  | red
 |  |  |  |  | red
 |  |  |  |  | red
 |  |  |  |  | red
 |  |  |  |  | red
 |  |  |  |  | red
 |  |  |  |  | red
 |  |  |  |  | red
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | red
 |  |  |  |  | red
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | red
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | red
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | red
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | red
 |  |  |  |  | purple
 |  |  |  |  | not relevant
 |  |  |  |  | green
 |  |  |  |  | purple
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | red
 |  |  |  |  | not relevant
 |  |  |  |  | red
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | green
 |  |  |  |  | not relevant
 |  |  |  |  | red
 |  |  |  |  | not relevant
 |  |  |  |  | red
 |  |  |  |  | red
 |  |  |  |  | not relevant
 |  |  |  |  | red
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | red
 |  |  |  |  | red
 |  |  |  |  | red
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | red
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | green
 |  |  |  |  | not relevant
 |  |  |  |  | red
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | red
 |  |  |  |  | red
 |  |  |  |  | red
 |  |  |  |  | not relevant
 |  |  |  |  | red
 |  |  |  |  | red
 |  |  |  |  | red
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | red
 |  |  |  |  | red
 |  |  |  |  | not relevant
 |  |  |  |  | red
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | red
 |  |  |  |  | not relevant
 |  |  |  |  | red
 |  |  |  |  | not relevant
 |  |  |  |  | red
 |  |  |  |  | not relevant
 |  |  |  |  | red
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | red
 |  |  |  |  | purple
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | red
 |  |  |  |  | not relevant
 |  |  |  |  | red
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | red
 |  |  |  |  | purple
 |  |  |  |  | red
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | red
 |  |  |  |  | purple
 |  |  |  |  | red
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | green
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | red
 |  |  |  |  | not relevant
 |  |  |  |  | red
 |  |  |  |  | red
 |  |  |  |  | not relevant
 |  |  |  |  | red
 |  |  |  |  | red
 |  |  |  |  | not relevant
 |  |  |  |  | red
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | red
 |  |  |  |  | red
 |  |  |  |  | red
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | red
 |  |  |  |  | not relevant
 |  |  |  |  | red
 |  |  |  |  | not relevant
 |  |  |  |  | red
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | red
 |  |  |  |  | red
 |  |  |  |  | purple
 |  |  |  |  | purple
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | red
 |  |  |  |  | red
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | red
 |  |  |  |  | red
 |  |  |  |  | red
 |  |  |  |  | red
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | not relevant
 |  |  |  |  | green
 |  |  |  |  | green
 |  |  |  |  | green
 |  |  |  |  | green