View original (French)

Excel formula "starts with"

Solved
eli67 -  
michel_m Posted messages 18903 Registration date   Status Contributor 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.

2 answers

  1.
    michel_m Posted messages 18903 Registration date   Status Contributor Last intervention   3 320
     
    Hello,
    IF(or(cpcli=59;cpcli=62);
    --
    Michel
    1