开发者

Excel nested IF's

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?


The problem is in the last word Error. It's not a valid name in Excel. Replace for example with "Error"

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜