J
Julie
Please help with the below formula
=IF(AND(H3>0,I3>0,J3>0),"Loyal$$$"),IF(AND(H3>0,I3>0,J3=0),"Retained$$0"),IF(AND(H3>0,I=0,J3>0),"Returning$0$"),IF(AND(H3>0,I3=0,J3=0),"New$00"),IF(AND(H3=0,I3>0,J3>0),"Lapsed0$$"),IF(AND(H3=0,I3>0,J3=0),"Lapsed0$0"),IF(AND(H3=0,I3=0,J3>0),"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),"ZDeadNNN"),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,I3>0,J3>0),"ZLaspedN$$"),IF(AND(H3<0,I3>0,J3<0),"ZLapsedN$N"),IF(AND(H3<0,I3>0,J3=0),"ZLapsedN$0"),IF(AND(H3<0,I3<0,J3>0),"ZLostNN$"),IF(AND(H3<0,I3=0,J3>0),"ZLostN0$"),IF(AND(H3=0,I3<0,J3>0),"ZLost0N$"),IF(AND(H3=0,I3>0,J3<0),"ZRecovering0$N"),IF(AND(H3>0,I3<0,J3>0),"ZRecovering$N$"),IF(AND(H3>0,I3<0,J3=0),"ZRecovering$N0"),IF(AND(H3>0,I3<0,J3<0),"ZRecovering$NN"),IF(AND(H3>0,I3=0,J3<0),"ZRecovering$0N"),IF(AND(H3>0,I3>0,J3<0),"ZRetained$$N")
=IF(AND(H3>0,I3>0,J3>0),"Loyal$$$"),IF(AND(H3>0,I3>0,J3=0),"Retained$$0"),IF(AND(H3>0,I=0,J3>0),"Returning$0$"),IF(AND(H3>0,I3=0,J3=0),"New$00"),IF(AND(H3=0,I3>0,J3>0),"Lapsed0$$"),IF(AND(H3=0,I3>0,J3=0),"Lapsed0$0"),IF(AND(H3=0,I3=0,J3>0),"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),"ZDeadNNN"),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,I3>0,J3>0),"ZLaspedN$$"),IF(AND(H3<0,I3>0,J3<0),"ZLapsedN$N"),IF(AND(H3<0,I3>0,J3=0),"ZLapsedN$0"),IF(AND(H3<0,I3<0,J3>0),"ZLostNN$"),IF(AND(H3<0,I3=0,J3>0),"ZLostN0$"),IF(AND(H3=0,I3<0,J3>0),"ZLost0N$"),IF(AND(H3=0,I3>0,J3<0),"ZRecovering0$N"),IF(AND(H3>0,I3<0,J3>0),"ZRecovering$N$"),IF(AND(H3>0,I3<0,J3=0),"ZRecovering$N0"),IF(AND(H3>0,I3<0,J3<0),"ZRecovering$NN"),IF(AND(H3>0,I3=0,J3<0),"ZRecovering$0N"),IF(AND(H3>0,I3>0,J3<0),"ZRetained$$N")