| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How can I test the text content of a cell
I wish to create a logical test - an IF statement that tests whether a cell
contains H, M or L, and output the result as a number. I cannot get the IF statement to recognise text as true or false - my Excel 2007 gives an error when I try to do something like IF(E9=H ....) is there a way to do this? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do I test for a text value in cell c1, if it is there, make c. | Excel Discussion (Misc queries) | |||
| Cell content in text box in chart | Charts and Charting in Excel | |||
| Formula that will test text conditions in a single cell | Excel Worksheet Functions | |||
| Cell text based on 4 condition test | Excel Worksheet Functions | |||
| How do I test a cell for part of text | Excel Worksheet Functions | |||
Threaded Mode
