 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / December 2006if(find..) problem
I used a formula like =IF(FIND("TELUS",D234)>0,C234,0) this works fine as long as the word TELUS is in cell D234 but gives #value! error otherwise. I would have expected 0. What should I have done instead? Try =IF(ISNUMBER(FIND("TELUS",D234)),C234,0)  SignatureRegards, Peo Sjoblom Excel 95 - Excel 2007 Northwest Excel Solutions www.nwexcelsolutions.com (Remove ^^ from email) >I used a formula like > =IF(FIND("TELUS",D234)>0,C234,0) > this works fine as long as the word TELUS is in cell D234 but gives > #value! error otherwise. I would have expected 0. What should I have done > instead? Another option: =if(countif(d234,"*telus*")>0,c234,0) > I used a formula like > =IF(FIND("TELUS",D234)>0,C234,0) > this works fine as long as the word TELUS is in cell D234 but gives #value! > error otherwise. I would have expected 0. What should I have done instead? SignatureDave Peterson thank you all countif did not work for me, but isnumber did. I am using excel 2002 sp3 >I used a formula like > =IF(FIND("TELUS",D234)>0,C234,0) > this works fine as long as the word TELUS is in cell D234 but gives > #value! error otherwise. I would have expected 0. What should I have done > instead? You may want to try it again--or post the formula that didn't work. (It worked fine for me.) > thank you all > [quoted text clipped - 6 lines] > > #value! error otherwise. I would have expected 0. What should I have done > > instead? SignatureDave Peterson
|
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.