View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dave F Dave F is offline
external usenet poster
 
Posts: 2,574
Default CREATE A LOGICAL TEST CONTAINING TEXT

=IF(A1=[A text],A logical response,if(A1=[B text],B logical response,[logical
response for neither A nor B))

Without more information about what your cells contain it's hard to give a
more concrete explanation.

"help needed" wrote:

I have a column containing text (a and b) info.
I want to do a logical test (if function) and get different results for a
and b.
any help appreciated