please helpp.

  • Thread starter Thread starter pierre
  • Start date Start date
P

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 )
 
I MEAN THAT I WOULD LIKE TO KEEP USING : CHOOSE AND MATCH TOGETHER
SO MY GOAL IS TO COMBINE THOSE TWO FORMULAS IN ONE
 
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 )
Click to expand...

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
 
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
 
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
 
Back
Top