CREATE A LOGICAL TEST CONTAINING TEXT

H

help needed

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
 
B

bj

try
=if(cell="a",a response,if(cell="b", b response, non a or b response))
and copy down.
(assuming you want to do this for each row)
 
D

Dave F

=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.
 
Top