因此，我试图堆叠一些=（（在Excel中的功能，我似乎可以在所使用的公式中找到问题，有人可以帮助我吗？

发布于 2025-02-07 12:28:12 字数 425 浏览 1 评论 0原文

= if（and（f2 = n2; g2＆gt; o2）;“ no notificar”;“ notificar”; if（and（f2 = n3; g2; g2＆gt; o3）;“ no notificar”;“ notificar”;“ notificar”;“ notificar”; if（and（f2） = n4; g2＆gt; o4）;“ no notificar”;“ notificar”; if（and（f2 = n5; g2; g2＆gt; o5）;“ no notificar”;“ notificar”;“ notificar”; if（and（f2 = n6; g2＆g2＆gt; o6））;“ no notificar”;“ notificar”; if（and（f2 = n7; g2＆gt; o7）;“ no notificar”;“ notificar”）））））））））））））））））））））））

原文

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

原来是傀儡 2025-02-14 12:28:13

正如@kromewing所说 - 对于IF公式，您输入了太多参数。

它应该具有逻辑计算，该计算将返回true/fals，然后如果它是真的，该怎么办，如果是错误的，该怎么办。

当前，您的公式读取为：

=IF(AND(F2=N2,G2>O2),"No Notificar","Notificar",
   IF(AND(F2=N3,G2>O3),"No Notificar","Notificar",
   IF(AND(F2=N4,G2>O4),"No Notificar","Notificar",
   IF(AND(F2=N5,G2>O5),"No Notificar","Notificar",
   IF(AND(F2=N6,G2>O6),"No Notificar","Notificar",
   IF(AND(F2=N7,G2>O7),"No Notificar","Notificar")))))

它应该更像：

=IF(AND(F2=N2,G2>O2),"No Notificar",
IF(AND(F2=N3,G2>O3),"No Notificar",
IF(AND(F2=N4,G2>O4),"No Notificar",
IF(AND(F2=N5,G2>O5),"No Notificar",
IF(AND(F2=N6,G2>O6),"No Notificar",
IF(AND(F2=N7,G2>O7),"No Notificar","Notificar"))))))

因此，如果第一个方程式为真，则不会显示Notificar，否则将测试第二个方程式。如果所有方程式返回false，则它将返回Notificar。

As @KromeWing said - you've entered too many parameters for an IF formula.

It should have a logical calculation that would return TRUE/FALSE and then what to do if it's TRUE and what to do if it's FALSE.

Currently your formula reads as:

=IF(AND(F2=N2,G2>O2),"No Notificar","Notificar",
   IF(AND(F2=N3,G2>O3),"No Notificar","Notificar",
   IF(AND(F2=N4,G2>O4),"No Notificar","Notificar",
   IF(AND(F2=N5,G2>O5),"No Notificar","Notificar",
   IF(AND(F2=N6,G2>O6),"No Notificar","Notificar",
   IF(AND(F2=N7,G2>O7),"No Notificar","Notificar")))))

It should look more like:

=IF(AND(F2=N2,G2>O2),"No Notificar",
IF(AND(F2=N3,G2>O3),"No Notificar",
IF(AND(F2=N4,G2>O4),"No Notificar",
IF(AND(F2=N5,G2>O5),"No Notificar",
IF(AND(F2=N6,G2>O6),"No Notificar",
IF(AND(F2=N7,G2>O7),"No Notificar","Notificar"))))))

So if the first equation is TRUE it will show No Notificar, otherwise it will test the second equation. If all equations return FALSE then it will return Notificar.

回复收藏 0 原文

只等公子 2025-02-14 12:28:13

如果只有3个参数。

您连续的IF应该是第三参数，此公式中没有第四参数。

回复收藏 0 原文

屌丝范 2025-02-14 12:28:13

如果（）可以接受四个参数，而不是三个。

我经常也被嵌套的IF弄乱了，这通常是由于不得不努力思考。

为了使自己变得更轻松，无论是在今天和下个月回到这个问题时，都必须弄清楚您要做什么，请尝试使用Alt-Enter在公式中添加新产品线，从而允许您要格式化您的公式：

=IF(test, valueIfTest,
IF(test2, valueIfTest2,
IF(test3, valueIfTest3,
...
valueIfAllTestsFail
)))

我发现，只要我坚持这种格式，语法的最难部分就会减少到结尾处的正确数量的关闭括号，但是由于如何使用Excel colorecodes匹配括号，即使我不流行咖啡因，我也可以管理！

You are expecting IF() to accept four arguments instead of three.

I often get messed up by nested ifs, too, and it's usually from having to think too hard.

To make things easier on yourself, both today and next month when you come back to this and have to try to figure out what the heck you were trying to do, try using alt-enter to add a new line within your formula, allowing you to format your formula like this:

=IF(test, valueIfTest,
IF(test2, valueIfTest2,
IF(test3, valueIfTest3,
...
valueIfAllTestsFail
)))

I find that as long as I stick to this format, the hardest part of the syntax is reduced to having the right number of closing parentheses at the end, but thanks to how Excel color-codes matching parentheses, I can manage that even when I'm caffeine-deprived!

回复收藏 0 原文

~没有更多了~