您为此函数输入了过多参数

Question

我的 Excel IF 函数抛出too manyArguments错误，但是如果我删除一个，就会出现缺少括号的错误。如果我添加一个，那就太多了。如果我去掉一个，那就不够了。我似乎找不到答案。

以下公式出现缺失错误：

=IF(AND(B8="Loose Stacked",D7<=10),12,IF(AND(B8="Loose Stacked",D7<=15),14,IF(AND(B8="Loose Stacked",D7>15),16,,IF(AND(B8="Barrel Stacked",D7<=10),12,IF(AND(B8="Barrel Stacked",D7<=15),14,IF(AND(B8="Barrel Stacked",D7>15),16,IF(AND(B8="Laced",D7<10),14,IF(AND(B8="Laced",D7<=15),16,IF(AND(B8="Laced",D7>15,18),18,))))))

以下公式错误太多：

=IF(AND(B8="Loose Stacked",D7<=10),12,IF(AND(B8="Loose Stacked",D7<=15),14,IF(AND(B8="Loose Stacked",D7>15),16,,IF(AND(B8="Barrel Stacked",D7<=10),12,IF(AND(B8="Barrel Stacked",D7<=15),14,IF(AND(B8="Barrel Stacked",D7>15),16,IF(AND(B8="Laced",D7<10),14,IF(AND(B8="Laced",D7<=15),16,IF(AND(B8="Laced",D7>15,18),18,)))))))

Answer 1

两种配方均含有：

16，，

删除其中一个逗号。