Excel formula "starts with"
Solved
eli67
-
michel_m Posted messages 18903 Registration date Status Contributeur Last intervention -
michel_m Posted messages 18903 Registration date Status Contributeur Last intervention -
Hello,
So here I would like to know how to say that the postal code must START with 59. Here is the formula:
=IF(G50=2,0,IF(TYPECLI="TRUE",0,IF(G8="Lille",5,IF(cpcli=59,10,15))))
Knowing that for the shipping costs to be €15, the postal code must start with 62 or 02. So I'm missing one more if. How should I do that?
Thank you.
So here I would like to know how to say that the postal code must START with 59. Here is the formula:
=IF(G50=2,0,IF(TYPECLI="TRUE",0,IF(G8="Lille",5,IF(cpcli=59,10,15))))
Knowing that for the shipping costs to be €15, the postal code must start with 62 or 02. So I'm missing one more if. How should I do that?
Thank you.