| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
formula to see if cell contains one of two text values
I am interested in writing a formula that will check to
see if a cell contains one of two words, and then will return a value. So, for example: =IF(ISNUMBER("textA" or "textB"),"yes","no") I know this formula isnt exactly correct. Can you help? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
formula to see if cell contains one of two text values
Hi
one way: =IF(OR(COUNTIF(A1,{"*textA*","*textB*"})),"yes","n o") -- Regards Frank Kabel Frankfurt, Germany " schrieb im Newsbeitrag ... I am interested in writing a formula that will check to see if a cell contains one of two words, and then will return a value. So, for example: =IF(ISNUMBER("textA" or "textB"),"yes","no") I know this formula isnt exactly correct. Can you help? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
formula to see if cell contains one of two text values
Brian
if you wanted to test cell A1, use: =IF(OR(A1="textA", A1="textB"),"yes","no") Regards Trevor " wrote in message ... I am interested in writing a formula that will check to see if a cell contains one of two words, and then will return a value. So, for example: =IF(ISNUMBER("textA" or "textB"),"yes","no") I know this formula isnt exactly correct. Can you help? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I want a formula to ignore text values in cell references | New Users to Excel | |||
| How do I sum cells that have values from a text formula? | Excel Worksheet Functions | |||
| ignoring text data in a cell when summing values in the same cell | New Users to Excel | |||
| formula with text values | Excel Discussion (Misc queries) | |||
| Build excel formula using field values as text in the formula | Excel Worksheet Functions | |||
Linear Mode
