Powered By Blogger

RFM

 =SI(Y(A2=5;B2=5;C2>=4);"Clientes VIP";SI(Y(A2>=4;B2>=3;C2>=3);"Clientes Leales";SI(Y(A2=5;B2<=3;C2<=3);"Clientes Potenciales";SI(Y(A2<=2;B2>=4;C2>=3);"Clientes en Riesgo";SI(Y(A2=1;B2<=2;C2<=2);"Clientes Perdidos";"Otros")))))

No hay comentarios:

Publicar un comentario

RFM

 =SI(Y(A2=5;B2=5;C2>=4);"Clientes VIP";SI(Y(A2>=4;B2>=3;C2>=3);"Clientes Leales";SI(Y(A2=5;B2<=3;C2<=3...