Usually - with over than 7 nested ifs - you will use a small helper table
from which you will return the appropriate value with the VLOOKUP function.
Excel 2007/2010 allows up to 64 nested ifs but it will be hard to
read/understand.
It is difficult to propose a more direct solution without having all the
details.
Micky


"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. Please help!!!

Thanks!
Daisy