| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF - looking in a cell for a specific value
In an IF statement, what do I need to write to say that if cell A1 contains
"fred", (i.e. " * fred * ") then.. "Yes". (I'm not sure what operator is needed to say 'contains') Any ideas? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
IF - looking in a cell for a specific value
Perhaps
=IF(ISERROR(SEARCH("Fred",A1)),"Not there","There") Mike "Sarah (OGI)" wrote: In an IF statement, what do I need to write to say that if cell A1 contains "fred", (i.e. " * fred * ") then.. "Yes". (I'm not sure what operator is needed to say 'contains') Any ideas? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
IF - looking in a cell for a specific value
On Nov 30, 10:15 pm, Sarah (OGI)
wrote: In an IF statement, what do I need to write to say that if cell A1 contains "fred", (i.e. " * fred * ") then.. "Yes". (I'm not sure what operator is needed to say 'contains') Any ideas? =IF(COUNTIF(A1,"*fred*")0,"Yes","No") Ken Johnson |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
IF - looking in a cell for a specific value
Try is with
=IF(SEARCH("fred";A1)0;"YES";"NO") greetz "Sarah (OGI)" schreef in bericht ... In an IF statement, what do I need to write to say that if cell A1 contains "fred", (i.e. " * fred * ") then.. "Yes". (I'm not sure what operator is needed to say 'contains') Any ideas? |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
IF - looking in a cell for a specific value
=IF(NOT(ISERROR(FIND("fred",A2))),"Yes","No")
or =IF(ISERROR(FIND("fred",A1)),"No","Yes") -- Kind regards, Niek Otten Microsoft MVP - Excel "Sarah (OGI)" wrote in message ... | In an IF statement, what do I need to write to say that if cell A1 contains | "fred", (i.e. " * fred * ") then.. "Yes". | (I'm not sure what operator is needed to say 'contains') | | Any ideas? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Not allowing to continu unless a specific cell has specific answer | Excel Discussion (Misc queries) | |||
| Link to specific cell in specific Excel file | Excel Discussion (Misc queries) | |||
| Link from a specific Cell in Excel to a specific para. in Word | Excel Worksheet Functions | |||
| Highlight a row if a specific cell is specific numbers/words | Excel Worksheet Functions | |||
| How do I make a cell date specific to input a value on a specific. | Excel Discussion (Misc queries) | |||
Linear Mode
