具有3个条件的Excel AND语句 [英] Excel AND statement with 3 conditions

问题描述

我在O2单元格中有此代码，并且可以正常工作.

I have this code in cell O2 and its working.

 =IF(OR(AND(M2=0;N2=0;I2>14);AND(N2<0,05;I2>14);AND(I2>14;N2<0,05););H2;"")

我想要这个附加条件.如果L2大于0，则O2也应为空. 向AND语句添加第3个条件无效.

I want this additional condition. O2 should be also empty if L2 is greater than 0. Adding a 3rd condition to the AND statements didnt work.

推荐答案

由于某种原因，我也遇到了将语句添加到AND的问题.您可以像这样将等式嵌套在另一个IF语句中

I also had an issue adding the statement to the AND for some reason. You could nest your equation inside another IF statement like so

O2 = IF(L2 > 0; ""; x)

其中x =您当前的方程式

where x = your current equation

这篇关于具有3个条件的Excel AND语句的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！