| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
CREATE A LOGICAL TEST CONTAINING TEXT
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
CREATE A LOGICAL TEST CONTAINING TEXT
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| create a text mask | Excel Discussion (Misc queries) | |||
| How would I create a text library? | Excel Discussion (Misc queries) | |||
| Create formula that will pull a value based on text in diff cell? | Excel Discussion (Misc queries) | |||
| Create text file | Excel Discussion (Misc queries) | |||
| change text color based on logical test | Excel Worksheet Functions | |||
Hybrid Mode
