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
|