IF with multiple arguments

[krokodilizm]

Guys can someone compare the below two and tell me where is the syntax error in 2nd formula? Formula 1 works fine (I copied it from a thread and changed inputs). In formula 2 I want to expand formula 1.

Formula 1 =IF(E5<=1625,(E5*0),IF(E5<=7000/3,(0+((E5-1625-E5*7.8%+$B$10/12+$B$11/12)*0.2)),(425/3+(E5-7000/3-E5*7.8%+$B$10/12+$B$11/12)*0.25)))

Formula 2 =IF(E9<=1625,(E9*0),IF(E9<=7000/3,(0+((E9-1625-E9*7.8%+$B$10/12+$B$11/12)*0.2)),(425/3+(E9-7000/3-E9*7.8%+$B$10/12+$B$11/12)*0.25))),(425.25+(E9-36300-E9*7.8%+$B$10/12+$B$11/12)*0.30)))),(4090/3+(E9-5000-E9*7.8%+$B$10/12+$B$11/12)*0.35)))))

The inputs are for tax calculation using different bands. First one calculates 2 bands, but I want to incorporate 4 bands.

 

[Joe4]

Though the result is not correct (must tweak some numbers) the syntax is error free.

Yep, that is why I didn't want to assume anything!

 

[krokodilizm]

try this

=IF(E9<=1625,0,IF(E9<=7000/3,(E9-1625-E9*7.8%+$B$10/12+$B$11/12)*0.2,IF(E9<=3025,425/3+(E9-7000/3-E9*7.8%+$B$10/12+$B$11/12)*0.25,IF(E9<=5000,5475/12+(E9-3025-E9*7.8%+$B$10/12+$B$11/12)*0.3,10885/12+(E9-5000-E9*7.8%+$B$10/12+$B$11/12)*0.35))))

Actually its all tip-top! Failed to notice this applies to 9th row (E9) and pasted instead on the first row.

 

[krokodilizm]

Yep, that is why I didn't want to assume anything!

Off to learn how to fish now that I ate one...

 

[AlanY]

Actually its all tip-top! Failed to notice this applies to 9th row (E9) and pasted instead on the first row.

glad that works for you