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)

"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