Search code examples
excelif-statementnestedconditional-statementsformula

Excel formula if multiple conditions

I have A2=1000000, I set the following formula at cell b2. I use if have multiple conditions but it is not working. The formula is

If(
    A2>=200000, 0%,
    if(
        300000<A2>0.5%，
        if(
            400000<=a2>0.6%%,
            if(
                500000<a2>400000,0.7%,
                if(a2>500000,1%)
            )
        )
    )
)

Appreciated anyone can help to solve it?

Regards, Joe

Solution

  • I did this with a lookup table as it is much easier to keep control - as you have found out trying to do your if():

    enter image description here