View original (French)

IIF or Nested TrueFalse

Solved
zonteomer74 -  
```excel
=SI([MOY1]>=10; "Admis"; "Refusé") & SI([Texte2]=1; "Abandon"; SI([Texte2]=2; "Exclus"; ""))
```

1 answer

  1.  zonteomer74 Author
    Hello everyone.
    After some research, I found the formula to address my concern regarding nested IIF with 4 conditions.
    Here it is:
    =IIF([Text127]="-1" And [Text127]="-1","NA",IIF([Text70]="Abst" And [Text70]="Abst","Abst",IIF([MOY1]>="1","Admitted","Rejected")))
    1