Excel中的双嵌套IF语句公式 [英] Double nested IF statement formula in Excel

问题描述

早上好

我想在Excel中设置一个if语句.

I would like to set a multiple if statement in Excel.

在第8行中，您可以看到以下公式，该列在Q列中给出了答案.基于此嵌套公式的答案是是"或否".

In row 8 you can see the following formula, which gives an answer in column Q. The answer based on this nested formula is Yes or No.

在第13行中，所有单元格均为空.由于嵌套公式已被向下拖动，因此仍显示否".

In row 13 all the cells are empty. Because the nested formula has been dragged down it still shows "No".

为此，我试图编写一些双嵌套IF语句，它可以涵盖单元格为空且Q列也可以为空的情况.

I was trying to write some double nested IF statement for this, which could cover the situation when the cells are empty and the Q column can come empty as well as a result.

   =IF(OR(M9=" ",OR(N9=" ",OR(O9=" ",OR(P9=" "(IF(OR(M9="No", OR(N9="No", OR(O9="No",OR(P9="No")))))),"Yes","No")," ")

不幸的是，该公式无法正常工作.

Unfortunately, the formula is not working.

是否可以为Excel中的嵌套IF语句添加附加条件?

Is it a possibility to add up an additional condition for the nested IF statement in Excel?

推荐答案

类似的东西

=IF(COUNTA(M2:P2),<YourFormula>,"")

当 M2:P2 中的任何值具有值时，< YourFormula> 是您感兴趣的任何公式的占位符.

Where <YourFormula> is a placeholder for whatever formula you are interested in when any value in M2:P2 has a value.

这篇关于Excel中的双嵌套IF语句公式的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！