excel - 在 Excel 中使用多个 IF 语句时出现问题

Question

我目前使用的公式是

=IF($X$4="in",IF(OR(T6="PLATE", T6="EXTR", T6="FLAT"),W7*25.4+10,IF(T6="SHEET",W7*25.4+50,IF(T6="ROUND",ROUNDUP(W7*25.4+8,)))), IF(OR(T6="PLATE", T6="EXTR", T6="FLAT"),W7+10,IF(T6="SHEET",W7+50,IF(T6="ROUND",ROUNDUP(W7+8,)))))

但是，现在我需要在开头添加一个附加条件，这对于计算公式来说似乎有点过分了 - IF(K6="SF", W6*25.4+100)。如果 K6 不 =SF 那么我需要它像往常一样继续使用公式。

我尝试过多种不同的方式，但我就是无法让它发挥作用。可能吗？

Answer 1

如果您像代码一样格式化(并缩进)公式，这会变得更容易处理。

这是您现有的公式:

=IF(
    $X$4="in",
    IF(
        OR(
            T6="PLATE", 
            T6="EXTR", 
            T6="FLAT"
        ),
        W7*25.4+10,
        IF(
            T6="SHEET",
            W7*25.4+50,
            IF(
                T6="ROUND",
                ROUNDUP(W7*25.4+8,)
            )
        )
    ),
    IF(
        OR(
            T6="PLATE", 
            T6="EXTR", 
            T6="FLAT"
        ),
        W7+10,
        IF(
            T6="SHEET",
            W7+50,
            IF(
                T6="ROUND",
                ROUNDUP(W7+8,)
            )
        )
    )
)

现在我们可以添加额外的 IF 语句:

=IF(
    K6="SF", 
    W6*25.4+100,
    IF(
        $X$4="in",
        IF(
            OR(
                T6="PLATE", 
                T6="EXTR", 
                T6="FLAT"
            ),
            W7*25.4+10,
            IF(
                T6="SHEET",
                W7*25.4+50,
                IF(
                    T6="ROUND",
                    ROUNDUP(W7*25.4+8,)
                )
            )
        ),
        IF(
            OR(
                T6="PLATE", 
                T6="EXTR", 
                T6="FLAT"
            ),
            W7+10,
            IF(
                T6="SHEET",
                W7+50,
                IF(
                    T6="ROUND",
                    ROUNDUP(W7+8,)
                )
            )
        )
    )
)