Logical Test: Text Against Number

  • Thread starter Thread starter rslaughter5
  • Start date Start date
R

rslaughter5

Can anyone provide insight into how Excel treats this type of test? For
example, why does Excel return TRUE when we have ="a">2 but FALSE when ="a"<2
(or any other number for that matter).

Thanks.
 
That's the way it is treated. Any kind of text is larger than the largest
number.
Any worth? hit the YES below
 
Back
Top