please helpp.

[pierre]

some help please.

i reached to the following :

=CHOOSE(MATCH("X";F7;0);5) which means if cell f7 has x
give me exactly 5

=CHOOSE(MATCH("y";F8;0);6) which means if cell f8 has y
give me exactly 6

MY QUESTION NOW.....IS IT POSSIBLE TO COMBINE THOSE TWO FORMULAS IN JUST
ONE ??? . ( I WANT IT SIMILAR TO [ IF(AND( ] FUNCTION )

 

[pierre]

I MEAN THAT I WOULD LIKE TO KEEP USING : CHOOSE AND MATCH TOGETHER
SO MY GOAL IS TO COMBINE THOSE TWO FORMULAS IN ONE

 

[Lars-Åke Aspelin]

some help please.

i reached to the following :

=CHOOSE(MATCH("X";F7;0);5) which means if cell f7 has x
give me exactly 5

=CHOOSE(MATCH("y";F8;0);6) which means if cell f8 has y
give me exactly 6

MY QUESTION NOW.....IS IT POSSIBLE TO COMBINE THOSE TWO FORMULAS IN JUST
ONE ??? . ( I WANT IT SIMILAR TO [ IF(AND( ] FUNCTION )

And what do you expect to get if both cell F7 has x and cell f8 has y?
5, 6, 11 or something else?

Lars-Åke

 

[Rick Rothstein \(MVP - VB\)]

Note: My system uses the comma, not the semi-colon, for a function's
argument delimiter.

I don't understand why you are using the CHOOSE function in your formulas...
there is only **one** item being chosen in each of them? I don't see why you
are not using a simple IF function to do this...

=IF(F7="x",5)

although you should probably provide a result for the false condition. If
you are insistent on using MATCH (although I can't see why), you could have
used...

=5*MATCH("x",F7,0)

for your first formula and...

=6*MATCH("y",F8,0)

for your second one. As for your request to combine them, Lars-Ã…ke has asked
the correct question... what if F7 contains "x" and F8 contains "y"? Or did
you have something different in mind when you asked your question?

Rick

 

[pierre]

dear sir...thanks for your reply...
but i would like to know the meaning of the formula you sent me :

=CHOOSE(condition1+2*condition2+1, neither, 1_only, 2_only, both)

....and in particular : 2*condition2+1

thanks in advance