View original (French)

IIF or Nested TrueFalse

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

1 answer

Answer 1 / 1
zonteomer74 Posted messages 31 Status Member 2
 
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