我有一个如下所示的 If(and) 公式。我想弄清楚如何实现，如果 E28 为空，则 L28 也将留空，而不是显示通过或失败。有人可以帮忙吗？
=IF(AND(E28<=$V$9,E28>=$W$9,F28<=$V$10,F28>=$W$10,G28<=$V$11,G28>=$W$11,H28<=$V$12,H28>=$W$12,I28<=$V$13,I28>=$W$13,J28<=$V$14,J28>=$W$14),"Pass","Fail")
答案1
将您的 if 嵌套在另一个 if 中：
=IF(E28 = "","",IF(AND(E28<=$V$9,E28>=$W$9,F28<=$V$10,F28>=$W$10,G28<=$V$11,G28>=$W$11,H28<=$V$12,H28>=$W$12,I28<=$V$13,I28>=$W$13,J28<=$V$14,J28>=$W$14),"Pass","Fail"))