Text Box / Cell Evaluation Not Consistant

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Whenever I comapre the value of a Reference Cell to the value of a TextBox LinkCell using an IF statement, I get conflicting results. If I compare two alphanumeric values the return is TRUE, whereas two numbers return a FALSE. I used the Evaluate Formula function and noticed that the value of the LinkCell is enclosed in quotes so I assume LinkCells are alway Text, but when I format the Reference Cell as Text, I get the same FALSE return. Any suggestions on why this might be happening?
 
A textbox always returns text.

Something like this (where A1 is linked cell, B1 numeric) ....... ?

=IF(VALUE(A1)=B1,"Match","NoMatch"
 
Thanks Brian... My fault for not figuring a text box returns text - DUH! I'll use an IF formula to convert it to a number if there are no alpha characters involved. Thanks again.
 
Back
Top