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,...

You say cell B4 but your formula says cell B15.

Create this 3 column table:

0...529...0.1
943...942...0.15
2914...2913...0.25
3618...3617...0.27
4772...4771...0.25
5580...5579...0.28
8347...8346...0.33
14670...14669...0.35

Assume that table is in the range B18:D25

This formula will do what your *current* nested IF formula is doing:

=(B15-LOOKUP(B15,B18:C25))*LOOKUP(B15,B18:D25)

Ok, so it sounds like you want to tweak this for the condition <529 = 0.

Just add a new line to the table:

0...0...0
529...529...0.1
943...942...0.15
2914...2913...0.25
3618...3617...0.27
4772...4771...0.25
5580...5579...0.28
8347...8346...0.33
14670...14669...0.35

Now the table range is B18:D26

The formula is the same, just uses the new table range:

=(B15-LOOKUP(B15,B18:C26))*LOOKUP(B15,B18:D26)

--
Biff
Microsoft Excel MVP


"Daisy77" wrote in message
...
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