Google Sheet中Dropdown联动QUERY+IF公式故障修复请求

• 背景：Google Sheets初学者，此前公式被大幅修改后无法理解，现需修复A3的IF+QUERY公式
• 现状：A2单元格公式可根据下拉选项正常筛选数据，但A3公式无法返回对应选项结果
• 要求：不改动A2的代码逻辑，仅修复A3公式

A2可用公式 #

=IF(A2="ALL WARD LICENSE APPLICATIONS", 
  QUERY(ALL!B3:K,"SELECT * "),
 IF(A2="WARD 1 LICENSE APPLICATIONS", 
    QUERY(ALL!B3:K, 
          "SELECT * WHERE D CONTAINS 'MP 01/' "),
 IF(A2="WARD 2 LICENSE APPLICATIONS", 
    QUERY(ALL!B3:K, 
          "SELECT * WHERE D CONTAINS 'MP 02/' "),
 IF(A2="WARD 3 LICENSE APPLICATIONS", 
    QUERY(ALL!B3:K, 
          "SELECT * WHERE D CONTAINS 'MP 03/' "),
 IF(A2="WARD 4 LICENSE APPLICATIONS", 
    QUERY(ALL!B3:K, 
          "SELECT * WHERE D CONTAINS 'MP 04/' "),
 IF(A2="WARD 5 LICENSE APPLICATIONS", 
    QUERY(ALL!B3:K, 
          "SELECT * WHERE D CONTAINS 'MP 05/' "),
 IF(A2="WARD 6 LICENSE APPLICATIONS", 
    QUERY(ALL!B3:K, 
          "SELECT * WHERE D CONTAINS 'MP 06/' "),

（注：A2公式虽未写完闭合括号，但实际使用中可正常运行，故保持原有结构）

A3故障公式 #

IF(A3="ALL APPLICATIONS", 
  QUERY(ALL!B3:K,"SELECT * "),

 IF(A3="ALL NEW LICENSE APPLICATIONS", 
    QUERY(ALL!B3:K, 
          "SELECT * WHERE H CONTAINS 'NEW LICENSE APPLICATION' "),

IF(A3="ALL RENEWAL LICENSE APPLICATIONS", 
      QUERY(ALL!B3:K, 
            "SELECT * WHERE H CONTAINS 'RENEWAL LICENSE APPLICATIONS' "),

IF(A3="FEE NOT PAIND", 
      QUERY(ALL!B3:K, 
            "SELECT * WHERE K CONTAINS 'FEE PENDING' "),
)))))))))))

故障原因及修复方案 #

故障点： #

1. 公式未以=开头，Google Sheets公式必须以等号启动
2. 选项文本拼写错误：FEE NOT PAIND应为FEE NOT PAID
3. RENEWAL条件匹配文本错误：H列实际文本为RENEWAL LICENSE APPLICATION（单数），原公式写成复数RENEWAL LICENSE APPLICATIONS
4. 闭合括号数量过多，与IF层级不匹配

修复后的A3公式（完全匹配A2的逻辑结构） #

=IF(A3="ALL APPLICATIONS", 
  QUERY(ALL!B3:K,"SELECT * "),
 IF(A3="ALL NEW LICENSE APPLICATIONS", 
    QUERY(ALL!B3:K, 
          "SELECT * WHERE H CONTAINS 'NEW LICENSE APPLICATION' "),
 IF(A3="ALL RENEWAL LICENSE APPLICATIONS", 
    QUERY(ALL!B3:K, 
          "SELECT * WHERE H CONTAINS 'RENEWAL LICENSE APPLICATION' "),
 IF(A3="FEE NOT PAID", 
    QUERY(ALL!B3:K, 
          "SELECT * WHERE K CONTAINS 'FEE PENDING' ")
))))

内容的提问来源于stack exchange，提问作者ACHU