Excel 嵌套 IF
我发现了几个谈论解决方法的网站，但它们都谈论做某种数学方程，所以这是我试图修复的嵌套 if 。
=IF((COUNTIF($A$137:$A$146,$C173)=1), 9203, IF((COUNTIF($A$161:$A$196,$C173)=1), 9202, IF((COUNTIF($A$199:$A$228,$C173)=1),9216, IF((COUNTIF($A$231:$A$255,$C173)=1),9222, IF((COUNTIF($A$258:$A$295,$C173)=1),9202, IF((COUNTIF($A$199:$A$228,$C173)=1),9216, IF((COUNTIF($A$298:$A$312,$C173)=1),9203, IF((COUNTIF($A$327:$A$361,$C173)=1),9202, IF((COUNTIF(A364:A383,$C173)=1),9219, Error)))))))))
有什么建议吗？
I have found several sites that talk about work arounds but they all talk about doing some kind of mathematical equation, so this is the nested if's I am trying to fix.
=IF((COUNTIF($A$137:$A$146,$C173)=1), 9203, IF((COUNTIF($A$161:$A$196,$C173)=1), 9202, IF((COUNTIF($A$199:$A$228,$C173)=1),9216, IF((COUNTIF($A$231:$A$255,$C173)=1),9222, IF((COUNTIF($A$258:$A$295,$C173)=1),9202, IF((COUNTIF($A$199:$A$228,$C173)=1),9216, IF((COUNTIF($A$298:$A$312,$C173)=1),9203, IF((COUNTIF($A$327:$A$361,$C173)=1),9202, IF((COUNTIF(A364:A383,$C173)=1),9219, Error)))))))))
Any tips?
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
问题出在最后一个词Error。这不是 Excel 中的有效名称。例如替换为“错误”
The problem is in the last word Error. It's not a valid name in Excel. Replace for example with "Error"