CODEWITHSUNDEEP
excel
Kaleembukhari
Kaleembukhari

Reputation: 5

Excel Syntax "False" Error

= IF(
    H2="Sandy loom",
    IF(
        AND(H1>=0,H1<=10),
        D2,
        IF(
            AND(H1>10,H1<=100),
            D3,
            IF(
                H2="sandy",
                IF(
                    AND(H1>=0,H1<=10),
                    D2,
                    IF(
                        AND(H1>10,H1<=100),
                        D3,
                        "Check"
                    )
                )
            )
        )
    )
)

This syntax keep returning FALSE when H2="sandy". I want it to execute the other half of the syntax after recognizing H2="sandy".

Upvotes: 0

Views: 47

Answers (1)

Karl Kristjansson
Karl Kristjansson

Reputation: 328

Here you go, works for me.

=IF(H2="Sandy loom",IF(AND(H1>=0,H1<=10),D2,IF(AND(H1>10,H1<=100),D3)),IF(H2="sandy",IF(AND(H1>=0,H1<=10),D2,IF(AND(H1>10,H1<=100),D3,"Check"))))

When doing large if's like this, it helps to break them down to manageable pieces.

It is much easier to combine these two than to create one large one in one go.

=IF(H2="Sandy loom",IF(AND(H1>=0,H1<=10),D2,IF(AND(H1>10,H1<=100),D3)))

=IF(H2="sandy",IF(AND(H1>=0,H1<=10),D2,IF(AND(H1>10,H1<=100),D3,"Check")))

The three brackets closing the first half are closing 3 different if formulas. If you want the second half to be an if to:

IF(H2="Sandy loom"

Then you need to place your second half in front of the last bracket in the first half, and then move that last bracket to the end of the entire formula.

=IF(H2="Sandy loom",IF(AND(H1>=0,H1<=10),D2,IF(AND(H1>10,H1<=100),D3))XXX)

Your second half needs to go where the XXX is located here, then its becomes the false of your first IF.

Upvotes: 1

Related Questions