Logical Test: Text Against Number

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.
 
M

Max

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