vendredi 15 février 2019

IFAND rule in excel

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