CREATE A LOGICAL TEST CONTAINING TEXT

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

=IF(I2="",IF(F3>0,F3,""),IF(F3>0,(F3+1)*(I2+1)-1,"")) ERROR?? 0
How can I test the text content of a cell 4
Can I use 'CONTAINS' in an IF Logical Test? 2
Split column contents (de-concantenate) 7
Find certain text in a cell 3
Ms Excel Multiple Logical Test Function 0
find text string to use in a sumproduct 3
Excel If a Cell Contains a Certain Text (From Another Table) 0

Back
Top