| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
If formula and text search
Normally you set up as A1 = 1, 'value if true', 'value if false'.
Can you set one up such that A1= "Text" if A1 contains "Text is a value" I've tried entering A1="Text*" I thought maybe a wildcard, but how can I get my formula to return the true value withough altering my A1 cell that says "Text is a value". Any help would be appreciated. Jason |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Search for Text within a Formula Result Q | Excel Worksheet Functions | |||
| vlookup formula fails to return data search item is text | Excel Worksheet Functions | |||
| Text search within a string using formula | Excel Worksheet Functions | |||
| Search, find or lookup defined text in text string | Excel Worksheet Functions | |||
| Search column and move text formula | Excel Discussion (Misc queries) | |||
Threaded Mode
