Match function: error due to format?
 

Hi
I am having big trouble because the argument I use for the VALUE in the Match function seems to be in the wrong format.

The value is not a number I hardcoded, but a number resulting from a formula combining "IF...RIGHT...CELL..."

the result is = 9

Let's assume this result is in cell A1

if I now use MATCH(A1;7/8/9;0)
the results is NA
and my original 9 is showed (in the Match Arguments) like this: "9"
instead of the pure number 9.

Obviously if I hardcode 9 in A1, the match formula works properly becase I have now 9 instead of "9" in the VALUE argument

how to solve it??? is there any formula to convert my result in A1?

thanks in advance

Match function: error due to format?
 

hi,

in cell A1

=SI( ... DROITE ... CELLULE)*1

or

=--SI( ... DROITE ... CELLULE)

--
isabelle



Le 2012-04-05 09:13, via sarpi a écrit :
Hi
I am having big trouble because the argument I use for the VALUE in the Match function seems to be in the wrong format.

The value is not a number I hardcoded, but a number resulting from a formula combining "IF...RIGHT...CELL..."

the result is = 9

Let's assume this result is in cell A1

if I now use MATCH(A1;7/8/9;0)
the results is NA
and my original 9 is showed (in the Match Arguments) like this: "9"
instead of the pure number 9.

Obviously if I hardcode 9 in A1, the match formula works properly becase I have now 9 instead of "9" in the VALUE argument

how to solve it??? is there any formula to convert my result in A1?

thanks in advance

Match function: error due to format?
 

hi,

in cell A1

=IF(...RIGHT...CELL...)*1

or

=--IF(...RIGHT...CELL...)

--
isabelle

Match function: error due to format?
 

Isabelle,

je t'adooooooooooooooooore!!!!
merci beaucoup!

Match function: error due to format?
 

c'est avec plaisir sarpi,

--
isabelle


Le 2012-04-05 09:42, via sarpi a écrit :
Isabelle,

je t'adooooooooooooooooore!!!!
merci beaucoup!