Google Sheets函数异常：仅前两个条件生效其余无输出

原函数的括号嵌套错误是核心问题——每个IF语句的value_if_true部分（即CHOOSE函数）后没有正确闭合括号，导致后续的IF条件被错误嵌套进前一个CHOOSE的参数里，只有前两个条件能被正常识别，其余条件无法触发。

以下是修正后的函数，修复了括号嵌套问题并优化了格式：

=IF(AND(D26="CLEAR", E26="CLEAR"), "CLEAR",
 IF(AND(D26="CLEAR", E26="CARRIER"), CHOOSE(RANDBETWEEN(1,2), "CLEAR", "CARRIER"),
  IF(AND(D26="CARRIER", E26="CLEAR"), CHOOSE(RANDBETWEEN(1,2), "CLEAR", "CARRIER"),
   IF(AND(D26="CLEAR", E26="AFFECTED"), CHOOSE(RANDBETWEEN(1,3), "CLEAR", "CARRIER", "AFFECTED"),
    IF(AND(D26="CARRIER", E26="CARRIER"), CHOOSE(RANDBETWEEN(1,3), "CLEAR", "CARRIER", "AFFECTED"),
     IF(AND(D26="CARRIER", E26="AFFECTED"), CHOOSE(RANDBETWEEN(1,3), "CLEAR", "CARRIER", "AFFECTED"),
      IF(AND(D26="AFFECTED", E26="AFFECTED"), CHOOSE(RANDBETWEEN(1,3), "CLEAR", "CARRIER", "AFFECTED"),
       IF(AND(D26="AFFECTED", E26="CLEAR"), CHOOSE(RANDBETWEEN(1,3), "CLEAR", "CARRIER", "AFFECTED"),
        IF(AND(D26="AFFECTED", E26="CARRIER"), CHOOSE(RANDBETWEEN(1,3), "CLEAR", "CARRIER", "AFFECTED"), "")
       )
      )
     )
    )
   )
  )
 )
)

修正说明 #

• 为每个IF语句的value_if_true部分添加了闭合括号，确保每个条件分支独立生效
• 移除了CHOOSE函数末尾多余的逗号，避免语法错误
• 统一缩进格式，让嵌套结构更易读

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