![如何在 1 个单元格中输入多个公式](https://linux22.com/image/1633898/%E5%A6%82%E4%BD%95%E5%9C%A8%201%20%E4%B8%AA%E5%8D%95%E5%85%83%E6%A0%BC%E4%B8%AD%E8%BE%93%E5%85%A5%E5%A4%9A%E4%B8%AA%E5%85%AC%E5%BC%8F.png)
我有一个如下所示的 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"))