Why don't you GOOGLE the following:

Excel's CHOOSE function

You'll be busy reading for the next couple of hours...
--
Kevin Backmann


"pierre" wrote:

can you PLEASE indicate me where i can find an example of a spreadsheet where
i can see an example of CHOOSE function in all its forms and variations ??

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