View original (French)

Formula: If with 3 conditions

Solved
Cabrina Posted messages 273 Status Member -  
 Untel -
Hello,

I'm looking to create a formula with 3 conditions:

I have a first column with 0, 2, or 7
I would like the following result: if I have the number 0 or 7 I want index 1, if it's 2 index 0

Thank you in advance,

Configuration: Windows / Internet Explorer 10.0

4 answers

  1.
    PHILOU10120 Posted messages 6463 Registration date   Status Contributor Last intervention   835
     
    Hello Cabrina

    Try this

    =IF(OR(A1=0,A1=7),1,0)

    --
    It is by forging that one becomes a blacksmith. - It is at the foot of the wall that one sees the mason - one always learns from their mistakes.
    1
    1. Cabrina Posted messages 273 Status Member 8
       
      Simple but effective, thank you very much :)
      0