"Daisy77" wrote:
This is my current formula:
=IF(B15<943,(B15-529)*0.1,
IF(B15<2914,(B15-942)*0.15,
IF(B15<3618,(B15-2913)*0.25,
IF(B15<4772,(B15-3617)*0.27,
IF(B15<5580,(B15-4771)*0.25,
IF(B15<8347,(B15-5579)*0.28,
IF(B15<14670,(B15-8346)*0.33,
IF(B1514669,(B15-14669)*0.35,0))))))))

I just realized that the your tax table structure is unlike any that I have
seen before. For my edification, please identify the government and purpose
this tax structure.

Obviously, you have some mistakes. The formula above would return negative
tax for any amount less than 529. I wonder if you have other mistakes as
well.

If not, then the following might be the best way to accomplish the same thing:

=MAX(0, (B15-VLOOKUP(A10,$X$1:$Z$8,3))
*VLOOKUP(B51,$X$1:$Z$8,2))

where X1:X8 contains 0, 943, 2914, 3618, 4772, 5580, 8347, 14670; Y1:Y8
contains 10%, 15%, 25%, 27%, 25%, 28%, 33%, 35%; Z1 contains 529, Z2 contains
=X2-1, and copy Z2 down through Z8.

(Caveat: look for any typos of mine.)

Is there some reason why you cannot use VLOOKUP?


----- original message -----

"Daisy77" wrote:
Hello everybody,

I currently have an IF statement w/8 sequences and it is working properly.
I'm doing this for tax purposes. When I try to add one more sequence, it
doesn't work. basically I just want to say If B4<529,0. I want it to return
a value of zero if cell B4 is < 529.

This is my current formula:
=IF(B15<943,(B15-529)*0.1,IF(B15<2914,(B15-942)*0.15,IF(B15<3618,(B15-2913)*0.25,IF(B15<4772,(B15-3617)*0.27,IF(B15<5580,(B15-4771)*0.25,IF(B15<8347,(B15-5579)*0.28,IF(B15<14670,(B15-8346)*0.33,IF(B1514669,(B15-14669)*0.35,0))))))))

Please help!!!

Thanks!
Daisy