I’m trying to add multiple conditions in one cell
I’m doing this:
=SI(OU(A3=$A$1;A3>$A$1);"OK");SI(ET(A3<$A$1;B3<>0);"Nope");SI(OU(B3=0;B3="");"SO")
I don’t understand where is my problem ?
Someone can explain me
>Solution :
Every IF statement needs a TRUE and FALSE value for a condition. Your parentheses are in the wrong spots; you have to nest the IFS like this:
=SI(OU(A3=$A$1;A3>$A$1);"OK";SI(ET(A3<$A$1;B3<>0);"Nope";SI(OU(B3=0;B3="");"SO";"Omelet du fromage")))
Or in English:
=IF(OR(A3=$A$1;A3>$A$1);"OK";IF(AND(A3<$A$1;B3<>0);"Nope";IF(OR(B3=0;B3="");"SO";"Omelet du fromage")))