if(find..) problem

[gs]

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?

 

[Peo Sjoblom]

Try

=IF(ISNUMBER(FIND("TELUS",D234)),C234,0)


--


Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
(Remove ^^ from email)

 

[Dave Peterson]

Another option:

=if(countif(d234,"*telus*")>0,c234,0)

 

[gs]

thank you all

countif did not work for me, but isnumber did.
I am using excel 2002 sp3

 

[Dave Peterson]

You may want to try it again--or post the formula that didn't work.

(It worked fine for me.)