错误IFS要求所有参数位于位置0之后

Question

我试图根据一个值引用一个单元格，但当我使用以下代码时，我得到了一个#N/a错误，注意IFS希望位置0之后的所有参数成对。

=IFS(OR(MONTH(TODAY))=-1，MONTH(TODAY())=4)，IFS(I10=true，"Completed"，A10="NOT STARTED"，"；⛔未启动"；，L10＝3/9；在"轨道上"；，L10＝2/9；在"轨道上"；，J19＝1/9；在"轨道上"；，L10<2/9；风险"，)，MONTH(TODAY())=5，IFS(I10=true，"完成"，A10="未启动"，"；⛔未启动"；，L11＝3/9；在"轨道上"；，L11＝2/9；在"轨道上"；，L11<2/9；处于危险中")，MONTH(TODAY())＝6，IFS(I10＝true，"完成"，A10＝"未启动"，"；⛔未启动"；，L12=3/9；在"轨道上"；，L12=2/9；在"轨道上"；，L12<2/9；风险")

Answer 1

您的公式可能在L10<2/9," At Risk",中有一个额外的尾随逗号，或者可能缺少每个ifs()的默认值。试试这个：

=ifs(
or(month(today()) = -1, month(today()) = 4),
ifs( 
I10 = true, "   Completed", 
A10 = "NOT STARTED", "⛔ Not Started", 
L10 = 3/9, "   On Track", 
L10 = 2/9, "   On Track", 
J19 = 1/9, "   On Track", 
L10 < 2/9, "   At Risk", 
true, na() 
), 
month(today()) = 5, 
ifs( 
I10 = true, "   Completed", 
A10 = "NOT STARTED", "⛔ Not Started", 
L11 = 3/9, "   On Track", 
L11 = 2/9, "   On Track", 
L11 < 2/9, "   At Risk", 
true, na() 
), 
month(today()) = 6, 
ifs( 
I10 = true, "   Completed", 
A10 = "NOT STARTED", "⛔ Not Started", 
L12 = 3/9, "   On Track", 
L12 = 2/9, "   On Track", 
L12 < 2/9, "   At Risk", 
true, na() 
) 
)

我不太明白为什么第一个or()有month(today()) = -1的测试。我认为这永远不会对true产生影响。