But by adding 1 to the True/False, it'll make excel treat True as 1 and false as
0.

should have been
But by multiplying 2 times the True/False, it'll make excel treat True as 1 and
false as 0.

Dave Peterson wrote:

(c9="Y")
will return true or false.

But by adding 1 to the True/False, it'll make excel treat True as 1 and false as
0.

So 2*(c9="y")
will return
2 or 0 (2*true or 2*false) or (2*1 or 2*0)

Then 1 is added to the result.
So you end up with: 3 or 1



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 ???

--

Dave Peterson

--

Dave Peterson