What i am trying to do is for example if O5 contain the word "update" then put "set" in P5. Thanks
A algebroni Feb 15, 2007 #1 What i am trying to do is for example if O5 contain the word "update" then put "set" in P5. Thanks
C Chip Pearson Feb 15, 2007 #2 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)
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)
