Right() not working

[keithm1]

I am trying to extract a number from the text string "10~13" located at Col A, Row 3 by using the formula RIGHT(A3,2) located in B3. I get the result in B3 of "13". But when I test it with the formula IF(B3=13,"Y","N") located in C3, I get the result "N". I have tested the length of B3 with LEN(B3) in D4 and get the result of "2". The format for Cell B3 is "Number" with no decimals. How can I extract the number from Cell A3 and have it equal the number to satisfy the IF test?
keithm1

 

[Rick Rothstein]

I am trying to extract a number from the text string "10~13" located at Col A, Row 3 by using the formula RIGHT(A3,2) located in B3. I get the result in B3 of "13". But when I test it with the formula IF(B3=13,"Y","N") located in C3, I get the result "N". I have tested the length of B3 with LEN(B3) in D4 and get the result of "2". The format for Cell B3 is "Number" with no decimals. How can I extract the number from Cell A3 and have it equal the number to satisfy the IF test?
keithm1

The RIGHT function returns text that looks like a number... you are trying to compare it to a real number which is a completely different thing. Try putting quote marks around the 13 so the equality test will be text against text.

 

[Redwolfx]

=if(value(b3)=13,"y","n")

 

[Jonmo1]

Welcome to the board.

The RIGHT function returns a TEXT string, not a Number (regardless of how the cell is formatted)
This is also true for many other funcitons like LEFT, MID, SUBSTITUTE, REPLACE

So you would do
IF(B3="13","Y","N")

Hope that helps.

 

[keithm1]

Thank all of you for your quick response and helpful suggestions. I'm glad to discover the "Value" function which I never used before. It solved the problem. The other solutions would also have worked but the Value function is easiest for my application. Thank you, thank you, thank you... Keith