I'm relatively new to excel so there may be an easy fix for this or I may have made it more complicated for myself. I have 4 columns of data- A B C D and I am trying to determine how many customers are "returning". So if A>0, B=0, and C>0 then I had a customer, they left, and then returned. Another example is if A>0, B>0, C=0, and D>0 then the customer has returned. However, if A=0 and B>0 and C>0 then the customer is still a customer.
=IFERROR(IF(A2>0,"TRUE",IF(AND(A2<0,'2015 Data'!B2>0),"TRUE",IF(AND('2015 Data'!A2<0,'2015 Data'!B2>0),"FALSE",IF(AND('2015 Data'!A2>0,'2015 Data'!B2<0,C2>0),"RETURN",IF(AND('2015 Data'!A2<0,'2015 Data'!B2<0,C2>Dashboard!$B$37),"NEW",IF(AND('2015 Data'!A2>0,'2015 Data'!B2<0,'2015 Data'!C2<0,D2>0),"RETURN",IF(AND('2015 Data'!B2>0,'2015 Data'!C2<0,D2>0),"RETURN",IF(AND('2015 Data'!A2<0,'2015 Data'!B2<0,'2015 Data'!C2<0,D2>0),"TRUE","FALSE")))))))),"ERROR")
So my problem is that the equation stops at when B2>0, but I need to know this equation (or a new equation) to go further and tell me if B>0 and C=0 and D>0 that it is "RETURN". Or alternatively to tell me that if A>0 and B=0 but C>0 that it is "RETURN".
I'm not completely sure if this makes sense or if there is even a way to do this but thank you for your help!
<tbody>
</tbody>
=IFERROR(IF(A2>0,"TRUE",IF(AND(A2<0,'2015 Data'!B2>0),"TRUE",IF(AND('2015 Data'!A2<0,'2015 Data'!B2>0),"FALSE",IF(AND('2015 Data'!A2>0,'2015 Data'!B2<0,C2>0),"RETURN",IF(AND('2015 Data'!A2<0,'2015 Data'!B2<0,C2>Dashboard!$B$37),"NEW",IF(AND('2015 Data'!A2>0,'2015 Data'!B2<0,'2015 Data'!C2<0,D2>0),"RETURN",IF(AND('2015 Data'!B2>0,'2015 Data'!C2<0,D2>0),"RETURN",IF(AND('2015 Data'!A2<0,'2015 Data'!B2<0,'2015 Data'!C2<0,D2>0),"TRUE","FALSE")))))))),"ERROR")
So my problem is that the equation stops at when B2>0, but I need to know this equation (or a new equation) to go further and tell me if B>0 and C=0 and D>0 that it is "RETURN". Or alternatively to tell me that if A>0 and B=0 but C>0 that it is "RETURN".
I'm not completely sure if this makes sense or if there is even a way to do this but thank you for your help!
<tbody>
</tbody>