You will have to tell us what you are trying to do. You seem to have many IF
statements, one after another, separated by commas. They aren't nested. For
example, the first one from your "formula" is:
=IF(AND(H30,I30,J30),"Loyal$$$")
That is a formula in itself - two opening brackets, two closing brackets -
so it should stop there. You can't just add to it!

"Julie" wrote in message
...
I think there is a problem with the statement itself...even when I narrow
this down to 7 conditions, I get a #VALUE error. Please help.

Julie

"Luke M" wrote:

Wow, is that a long one.

Not sure what all the trouble is, but you have too many nested IF
statements. You can only have 7 IF statements in a row. Now, you can
branch
them out, so that 7 IF statements follow the first IF's false line of
logic,
and another 7 IF's follow the true line of logic.

Is there any way you can break this down? I'm not sure what all your
trying
to get, but would a lookup table help?


--
Best Regards,

Luke M


"Julie" wrote:

Please help with the below formula

=IF(AND(H30,I30,J30),"Loyal$$$"),IF(AND(H30,I3 0,J3=0),"Retained$$0"),IF(AND(H30,I=0,J30),"Ret urning$0$"),IF(AND(H30,I3=0,J3=0),"New$00"),IF(AN D(H3=0,I30,J30),"Lapsed0$$"),IF(AND(H3=0,I30,J3 =0),"Lapsed0$0"),IF(AND(H3=0,I3=0,J30),"Lost00$") ,IF(AND(H3=0,I3=0,J3=0),"NoSales000"),IF(AND(H3=0, I3=0,J3<0),"ZDead00N"),IF(AND(H3<0,I3<0,J3<0),"ZDe adNNN"),IF(AND(H3<0,I3=0,J3=0),"ZDeadN00"),IF(AND( H3=0,I3<0,J3<0),"ZDead0NN"),IF(AND(H3<0,I3=0,J3<0) ,"ZDeadN0N"),IF(AND(H3=0,I3<0,J3=0),"ZDead0N0"),IF (AND(H3<0,I30,J30),"ZLaspedN$$"),IF(AND(H3<0,I3 0,J3<0),"ZLapsedN$N"),IF(AND(H3<0,I30,J3=0),"ZLap sedN$0"),IF(AND(H3<0,I3<0,J30),"ZLostNN$"),IF(AND (H3<0,I3=0,J30),"ZLostN0$"),IF(AND(H3=0,I3<0,J30 ),"ZLost0N$"),IF(AND(H3=0,I30,J3<0),"ZRecovering0 $N"),IF(AND(H30,I3<0,J30),"ZRecovering$N$"),IF(A ND(H30,I3<0,J3=0),"ZRecovering$N0"),IF(AND(H30,I 3<0,J3<0),"ZRecovering$NN"),IF(AND(H30,I3=0,J3<0) ,"ZRecovering$0N"),IF(AND(H30,I30,J3<0),"ZRetain ed$$N")