当第一个条件变为FALSE时，如何嵌套更多的IF条件？ [英] How to nest more IF conditions in excel when first condition becomes FALSE?

问题描述

excel不接受公式

The excel not accepting the formula

=IF(AND(Sheet1!BZ2<>"",Sheet1!CB2<>"",Sheet1!CD2<>"",Sheet1!CF2<>"",Sheet1!CH2<>"",Sheet1!CA2="",Sheet1!BC2="B"), IF(Sheet1!CA2="","",TODAY()-1),
    IF(
        IF(AND(Sheet1!BZ2<>"",Sheet1!CA2="",Sheet1!BC2="A"),IF(Sheet1!CA2="","",TODAY()-1),
            IF(
                IF(AND(OR(Sheet1!DB2="Completed - Knowledge Transfer"),AND(Sheet1!BC2<>"")),IF(Sheet1!CA2="","",TODAY()-1),
                IF(Sheet1!CA2="","",Sheet1!CA2)
                  )
       )
  )

我遵循 IF 的以下语法。

= IF（logical_test，[value_if_true ]，[value_if_false]）

每当语句得到 FALSE
请帮助。

I am trying to nest the other conditions whenever the statements gets FALSE Please help.

有人可以在这个

推荐答案

If语句不能正确嵌套，并且您正在使用一些再次不正确使用的AND或语句。

The If statement isn't nested properly and also you are using some AND Or statements which are again not used properly.

简化你的公式我们得到这个

Simplifying your formula we get this

=IF(a,b,IF(IF(c,d,IF(IF(e,f,g)))

其中，

 a = AND(Sheet1!BZ2<>"",Sheet1!CB2<>"",Sheet1!CD2<>"",Sheet1!CF2<>"",Sheet1!CH2<>"",Sheet1!CA2="",Sheet1!BC2="B") 

 b = IF(Sheet1!CA2="","",TODAY()-1)

 c = AND(Sheet1!BZ2<>"",Sheet1!CA2="",Sheet1!BC2="A")

 d = IF(Sheet1!CA2="","",TODAY()-1)

 e = AND(OR(Sheet1!DB2="Completed - Knowledge Transfer"),AND(Sheet1!BC2<>""))This does not make sense

 f = IF(Sheet1!CA2="","",TODAY()-1)

 g = IF(Sheet1!CA2="","",Sheet1!CA2)

正确的嵌套IF将是

=IF(a,b,IF(c,d,IF(e,f,g)))

这篇关于当第一个条件变为FALSE时，如何嵌套更多的IF条件？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！