This formula would do the same

=IF(B9="X";IF(C9="Y";both;5);IF(C9="Y";6;"neither" ))

"Pete_UK" wrote:

The first term (B9="X") is equivalent to IF(B9="X",TRUE,FALSE), but
the TRUE and FALSE will get converted to 1 or 0 through the addition,
so effectively this will return 1 or 0 depending on the value of B9.

The second term 2*(C9="Y") is similar - it will return 2 or 0
depending on the value of C9.

So, the first parameter of the CHOOSE function, (B9="X")+2*(C9="Y")+1,
can take on these values:

B9<"X" and C9<"Y" returns 1
B9="X" and C9<"Y" returns 2
B9<"X" and C9="Y" returns 3
B9="X" and C9="Y" returns 4

and the CHOOSE function itself will return "neither" for 1, 5 for 2, 6
for 3, or "both" for 4.

Hope this helps.

Pete

On Apr 19, 7:34 pm, pierre wrote:
can someone tell me the meanining of this formula :

=CHOOSE((B9="X")+2*(C9="Y")+1; "neither"; 5; 6;"both")

WHAT DOES THIS FUNCTION MEAN ?? : 2*(C9="Y")+1

IS THERE ANY OTHER VARIATIONS LIKE THIS FORMULA ???