View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
rslaughter5 rslaughter5 is offline
external usenet poster
 
Posts: 6
Default Logical Test: Text Against Number

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.