Ah ha! In all your statements, after the true value, you have parenthesis.
=IF(AND(H30,I30,J30),"Loyal$$$"),IF(AND...
This is closing your IF statement, which you don't want.

Should be:
=IF(AND(H30,I30,J30),"Loyal$$$",IF(AND....

Also, at least one of your I3 references is missing the number, creating
invalid callout.

--
Best Regards,

Luke M


"Julie" wrote:

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")

maybe you can help solve this one..

=IF(TODAY()=C3,0,NOW()-C3-1)

the days open are counted based on a start date manually inputed in C3, a closed date is manually inputed in a separate cell, for instance C4. I am trying to craft my IF statement to stop counting days open based on the closure date. Any suggestions?

Thx

Not sure but maybe

=IF(OR(C3=TODAY(),C4=""),0,C4-C3-1)

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



<FX wrote in message ...
maybe you can help solve this one..

=IF(TODAY()=C3,0,NOW()-C3-1)

the days open are counted based on a start date manually inputed in C3, a
closed date is manually inputed in a separate cell, for instance C4. I am
trying to craft my IF statement to stop counting days open based on the
closure date. Any suggestions?

Thx