Spreadsheet: 884249d1733330707-excel-formula-needed-nested-excel-forum-example1
Sheet: ACTIVITY

NOT REGISTERED |  | INVOICE | XYZ COMPANY | DATE DUE: | 2024-12-04 00:00:00 | TAXES: | STATE | GA | 0 | % | 0 | COUNTY | 0 | % | 0 | TAX 1 | 0 | % | 0 | TAX 2 | 0 | % | 0
 |  | INVOICE | XYZ COMPANY | DATE DUE: | 2024-11-06 00:00:00 | TAXES: | STATE | CA | 0 | % | 0 | COUNTY | 0 | % | 0 | TAX 1 | 0 | % | 0 | TAX 2 | 0 | % | 0
NOT REGISTERED |  | INVOICE | XYZ COMPANY | DATE DUE: | 2024-11-06 00:00:00 | TAXES: | STATE | TX | 6.25 | % | 545.31 | COUNTY | 0.5 | % | 43.62 | TAX 1 | 1.5 | % | 130.88 | TAX 2 | 0 | % | 0 |  |  | needed = formula in Column A
 |  | INVOICE | XYZ COMPANY | DATE DUE: | 2024-10-29 00:00:00 | TAXES: | STATE | TX | 0 | % | 0 | COUNTY | 0 | % | 0 | TAX 1 | 0 | % | 0 | TAX 2 | 0 | % | 0
 |  | INVOICE | XYZ COMPANY | DATE DUE: | 2024-10-29 00:00:00 | TAXES: | STATE | TX | 0 | % | 0 | COUNTY | 0 | % | 0 | TAX 1 | 0 | % | 0 | TAX 2 | 0 | % | 0 |  |  | as long as the states in Column I are:
 |  | INVOICE | XYZ COMPANY | DATE DUE: | 2024-10-29 00:00:00 | TAXES: | STATE | WA | 0 | % | 0 | COUNTY | 0 | % | 0 | TAX 1 | 0 | % | 0 | TAX 2 | 0 | % | 0 |  |  |  | CA
 |  | INVOICE | XYZ COMPANY | DATE DUE: | 2024-10-29 00:00:00 | TAXES: | STATE | IL | 0 | % | 0 | COUNTY | 0 | % | 0 | TAX 1 | 0 | % | 0 | TAX 2 | 0 | % | 0 |  |  |  | SC
 |  | INVOICE | XYZ COMPANY | DATE DUE: | 2024-10-29 00:00:00 | TAXES: | STATE | NY | 0 | % | 0 | COUNTY | 0 | % | 0 | TAX 1 | 0 | % | 0 | TAX 2 | 0 | % | 0 |  |  |  | MI
 |  | INVOICE | XYZ COMPANY | DATE DUE: | 2024-11-01 00:00:00 | TAXES: | STATE | OH | 0 | % | 0 | COUNTY | 0 | % | 0 | TAX 1 | 0 | % | 0 | TAX 2 | 0 | % | 0 |  |  |  | WA
 |  | INVOICE | XYZ COMPANY | DATE DUE: | 2024-12-01 00:00:00 | TAXES: | STATE | GA | 0 | % | 0 | COUNTY | 0 | % | 0 | TAX 1 | 0 | % | 0 | TAX 2 | 0 | % | 0 |  |  |  | WI
 |  | INVOICE | XYZ COMPANY | DATE DUE: | 2024-12-01 00:00:00 | TAXES: | STATE | GA | 0 | % | 0 | COUNTY | 0 | % | 0 | TAX 1 | 0 | % | 0 | TAX 2 | 0 | % | 0
 |  | INVOICE | XYZ COMPANY | DATE DUE: | 2024-12-01 00:00:00 | TAXES: | STATE | NJ | 0 | % | 0 | COUNTY | 0 | % | 0 | TAX 1 | 0 | % | 0 | TAX 2 | 0 | % | 0 |  |  | AND any amount is in columns
 |  | INVOICE | XYZ COMPANY | DATE DUE: | 2024-12-01 00:00:00 | TAXES: | STATE | NJ | 0 | % | 0 | COUNTY | 0 | % | 0 | TAX 1 | 0 | % | 0 | TAX 2 | 0 | % | 0 |  |  |  | L
 |  | INVOICE | XYZ COMPANY | DATE DUE: | 2024-12-01 00:00:00 | TAXES: | STATE | CA | 0 | % | 0 | COUNTY | 0 | % | 0 | TAX 1 | 0 | % | 0 | TAX 2 | 0 | % | 0 |  |  |  | P
 |  | INVOICE | XYZ COMPANY | DATE DUE: | 2024-12-01 00:00:00 | TAXES: | STATE | CA | 0 | % | 0 | COUNTY | 0 | % | 0 | TAX 1 | 0 | % | 0 | TAX 2 | 0 | % | 0 |  |  |  | T
 |  | INVOICE | XYZ COMPANY | DATE DUE: | 2024-12-01 00:00:00 | TAXES: | STATE | TX | 6.25 | % | 545.31 | COUNTY | 0.5 | % | 43.62 | TAX 1 | 1.5 | % | 130.88 | TAX 2 | 0 | % | 0 |  |  |  | X
 |  | INVOICE | XYZ COMPANY | DATE DUE: | 2024-12-01 00:00:00 | TAXES: | STATE |  | 5 | % | 70.23 | COUNTY | 0 | % | 0 | TAX 1 | 0 | % | 0 | TAX 2 | 0 | % | 0
 |  | INVOICE | XYZ COMPANY | DATE DUE: | 2024-12-01 00:00:00 | TAXES: | STATE |  | 5 | % | 70.23 | COUNTY | 0 | % | 0 | TAX 1 | 0 | % | 0 | TAX 2 | 0 | % | 0 |  |  | No response is necessary
 |  | INVOICE | XYZ COMPANY | DATE DUE: | 2024-12-01 00:00:00 | TAXES: | STATE | FL | 0 | % | 0 | COUNTY | 0 | % | 0 | TAX 1 | 0 | % | 0 | TAX 2 | 0 | % | 0
 |  | INVOICE | XYZ COMPANY | DATE DUE: | 2024-12-01 00:00:00 | TAXES: | STATE | FL | 0 | % | 0 | COUNTY | 0 | % | 0 | TAX 1 | 0 | % | 0 | TAX 2 | 0 | % | 0 |  |  | BUT if ANY amounts are in columns
 |  | INVOICE | XYZ COMPANY | DATE DUE: | 2024-12-01 00:00:00 | TAXES: | STATE | CO | 0 | % | 0 | COUNTY | 0 | % | 0 | TAX 1 | 0 | % | 0 | TAX 2 | 0 | % | 0 |  |  |  | L
 |  | INVOICE | XYZ COMPANY | DATE DUE: | 2024-12-01 00:00:00 | TAXES: | STATE | CO | 0 | % | 0 | COUNTY | 0 | % | 0 | TAX 1 | 0 | % | 0 | TAX 2 | 0 | % | 0 |  |  |  | P
 |  | INVOICE | XYZ COMPANY | DATE DUE: | 2024-12-01 00:00:00 | TAXES: | STATE | CO | 0 | % | 0 | COUNTY | 0 | % | 0 | TAX 1 | 0 | % | 0 | TAX 2 | 0 | % | 0 |  |  |  | T
 |  | INVOICE | XYZ COMPANY | DATE DUE: | 2024-12-01 00:00:00 | TAXES: | STATE |  | 0 | % | 0 | COUNTY | 0 | % | 0 | TAX 1 | 0 | % | 0 | TAX 2 | 0 | % | 0 |  |  |  | X
 |  | INVOICE | XYZ COMPANY | DATE DUE: | 2024-12-01 00:00:00 | TAXES: | STATE |  | 0 | % | 0 | COUNTY | 0 | % | 0 | TAX 1 | 0 | % | 0 | TAX 2 | 0 | % | 0
 |  | INVOICE | XYZ COMPANY | DATE DUE: | 2024-12-01 00:00:00 | TAXES: | STATE | NC | 0 | % | 0 | COUNTY | 0 | % | 0 | TAX 1 | 0 | % | 0 | TAX 2 | 0 | % | 0 |  |  | and the states are NOT:
 |  | INVOICE | XYZ COMPANY | DATE DUE: | 2024-12-01 00:00:00 | TAXES: | STATE | NC | 0 | % | 0 | COUNTY | 0 | % | 0 | TAX 1 | 0 | % | 0 | TAX 2 | 0 | % | 0 |  |  |  | CA
 |  | INVOICE | XYZ COMPANY | DATE DUE: | 2024-12-01 00:00:00 | TAXES: | STATE | NC | 0 | % | 0 | COUNTY | 0 | % | 0 | TAX 1 | 0 | % | 0 | TAX 2 | 0 | % | 0 |  |  |  | SC
 |  | INVOICE | XYZ COMPANY | DATE DUE: | 2024-12-01 00:00:00 | TAXES: | STATE | CA | 0 | % | 0 | COUNTY | 0 | % | 0 | TAX 1 | 0 | % | 0 | TAX 2 | 0 | % | 0 |  |  |  | MI
 |  | INVOICE | XYZ COMPANY | DATE DUE: | 2024-12-01 00:00:00 | TAXES: | STATE | CA | 0 | % | 0 | COUNTY | 0 | % | 0 | TAX 1 | 0 | % | 0 | TAX 2 | 0 | % | 0 |  |  |  | WA
 |  | INVOICE | XYZ COMPANY | DATE DUE: | 2024-11-01 00:00:00 | TAXES: | STATE | SC | 0 | % | 0 | COUNTY | 0 | % | 0 | TAX 1 | 0 | % | 0 | TAX 2 | 0 | % | 0 |  |  |  | WI
 |  | INVOICE | XYZ COMPANY | DATE DUE: | 2024-11-01 00:00:00 | TAXES: | STATE | SC | 0 | % | 0 | COUNTY | 0 | % | 0 | TAX 1 | 0 | % | 0 | TAX 2 | 0 | % | 0
 |  | INVOICE | XYZ COMPANY | DATE DUE: | 2024-11-01 00:00:00 | TAXES: | STATE | SC | 0 | % | 0 | COUNTY | 0 | % | 0 | TAX 1 | 0 | % | 0 | TAX 2 | 0 | % | 0 |  |  | I would like "not registered" to be returned in column A
 |  | INVOICE | XYZ COMPANY | DATE DUE: | 2024-11-01 00:00:00 | TAXES: | STATE | SC | 0 | % | 0 | COUNTY | 0 | % | 0 | TAX 1 | 0 | % | 0 | TAX 2 | 0 | % | 0
 |  | INVOICE | XYZ COMPANY | DATE DUE: | 2024-12-01 00:00:00 | TAXES: | STATE | CA | 0 | % | 0 | COUNTY | 0 | % | 0 | TAX 1 | 0 | % | 0 | TAX 2 | 0 | % | 0
 |  | INVOICE | XYZ COMPANY | DATE DUE: | 2024-12-01 00:00:00 | TAXES: | STATE | NY | 0 | % | 0 | COUNTY | 0 | % | 0 | TAX 1 | 0 | % | 0 | TAX 2 | 0 | % | 0 |  |  | (Column I will also be blank if outside the United States)
 |  | INVOICE | XYZ COMPANY | DATE DUE: | 2024-11-01 00:00:00 | TAXES: | STATE | NC | 0 | % | 0 | COUNTY | 0 | % | 0 | TAX 1 | 0 | % | 0 | TAX 2 | 0 | % | 0 |  |  | which will not matter here.
 |  | INVOICE | XYZ COMPANY | DATE DUE: | 2024-12-01 00:00:00 | TAXES: | STATE | PA | 0 | % | 0 | COUNTY | 0 | % | 0 | TAX 1 | 0 | % | 0 | TAX 2 | 0 | % | 0
 |  | INVOICE | XYZ COMPANY | DATE DUE: | 2024-12-04 00:00:00 | TAXES: | STATE | GA | 0 | % | 0 | COUNTY | 0 | % | 0 | TAX 1 | 0 | % | 0 | TAX 2 | 0 | % | 0
 |  | INVOICE | XYZ COMPANY | DATE DUE: | 2024-11-04 00:00:00 | TAXES: | STATE | WA | 0 | % | 0 | COUNTY | 0 | % | 0 | TAX 1 | 0 | % | 0 | TAX 2 | 0 | % | 0
 |  | INVOICE | XYZ COMPANY | DATE DUE: | 2024-11-11 00:00:00 | TAXES: | STATE | KS | 0 | % | 0 | COUNTY | 0 | % | 0 | TAX 1 | 0 | % | 0 | TAX 2 | 0 | % | 0
 |  | INVOICE | XYZ COMPANY | DATE DUE: | 2024-11-11 00:00:00 | TAXES: | STATE | KS | 0 | % | 0 | COUNTY | 0 | % | 0 | TAX 1 | 0 | % | 0 | TAX 2 | 0 | % | 0
 |  | INVOICE | XYZ COMPANY | DATE DUE: | 2024-11-12 00:00:00 | TAXES: | STATE |  | 0 | % | 0 | COUNTY | 0 | % | 0 | TAX 1 | 0 | % | 0 | TAX 2 | 0 | % | 0
 |  | INVOICE | XYZ COMPANY | DATE DUE: | 2024-11-12 00:00:00 | TAXES: | STATE |  | 0 | % | 0 | COUNTY | 0 | % | 0 | TAX 1 | 0 | % | 0 | TAX 2 | 0 | % | 0
 |  | INVOICE | XYZ COMPANY | DATE DUE: | 2024-11-19 00:00:00 | TAXES: | STATE | SC | 0 | % | 0 | COUNTY | 0 | % | 0 | TAX 1 | 0 | % | 0 | TAX 2 | 0 | % | 0
 |  | INVOICE | XYZ COMPANY | DATE DUE: | 2024-11-19 00:00:00 | TAXES: | STATE | AL | 0 | % | 0 | COUNTY | 0 | % | 0 | TAX 1 | 0 | % | 0 | TAX 2 | 0 | % | 0
 |  | INVOICE | XYZ COMPANY | DATE DUE: | 2024-11-19 00:00:00 | TAXES: | STATE | AL | 0 | % | 0 | COUNTY | 0 | % | 0 | TAX 1 | 0 | % | 0 | TAX 2 | 0 | % | 0
 |  | INVOICE | XYZ COMPANY | DATE DUE: | 2024-12-26 00:00:00 | TAXES: | STATE |  | 0 | % | 0 | COUNTY | 0 | % | 0 | TAX 1 | 0 | % | 0 | TAX 2 | 0 | % | 0
 |  | INVOICE | XYZ COMPANY | DATE DUE: | 2024-12-26 00:00:00 | TAXES: | STATE |  | 0 | % | 0 | COUNTY | 0 | % | 0 | TAX 1 | 0 | % | 0 | TAX 2 | 0 | % | 0
 |  | INVOICE | XYZ COMPANY | DATE DUE: | 2024-11-27 00:00:00 | TAXES: | STATE | SC | 0 | % | 0 | COUNTY | 0 | % | 0 | TAX 1 | 0 | % | 0 | TAX 2 | 0 | % | 0
 |  | INVOICE | XYZ COMPANY | DATE DUE: | 2024-12-27 00:00:00 | TAXES: | STATE |  | 0 | % | 0 | COUNTY | 0 | % | 0 | TAX 1 | 0 | % | 0 | TAX 2 | 0 | % | 0