| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help with a function
What i am trying to do is for example
if O5 contain the word "update" then put "set" in P5. Thanks |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Help with a function
If you want to test whether the word "update" appears in O5, possibly with
other text, use =IF(ISNUMBER(FIND("update",O5,1)),"set","") If you to test O5 for ONLY the word update, use =IF(O5="update","set","") If UPPER and lower case matters, use =IF(EXACT(O5,"UpDaTe"),"set","") -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com (email address is on the web site) "algebroni" wrote in message ... What i am trying to do is for example if O5 contain the word "update" then put "set" in P5. Thanks |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Help with a function
In P5...
=IF(O5="update","set","else do this") "algebroni" wrote: What i am trying to do is for example if O5 contain the word "update" then put "set" in P5. Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| LINKEDRANGE function - a complement to the PULL function (for getting values from a closed workbook) | Excel Worksheet Functions | |||
| Offset function with nested match function not finding host ss. | Excel Worksheet Functions | |||
| Using the autofill function but increment by certain number in function | Excel Worksheet Functions | |||
| Emulate Index/Match combo function w/ VBA custom function | Excel Worksheet Functions | |||
| Nested IF Function, Date Comparing, and NetworkDays Function | Excel Worksheet Functions | |||
Linear Mode
