I am trying to work in excel using IFAND rule to try and build the following logic however I am unsuccessful until now.
Department Date Customer
Digital 11/02/19 Customer A
Voice 14/02/19 Customer A
What I am trying to achieve is that, if customer A contacted us through a dept = digital and after voice it will return 1.
Can someone help please?
=if(and(A:A="Digital",B:B>b2,C:C=C2,A:A="Voice"),true,false)
This is the logic we have used so far.
Thanks!
Aucun commentaire:
Enregistrer un commentaire