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

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

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