View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Fred Smith[_4_] Fred Smith[_4_] is offline
external usenet poster
 
Posts: 2,389
Default IF function + a formula

Try something like:

=IF(ISNUMBER(FIND("home",A1)),((C2-criteria)-M2)/60,"not found")

BTW, "=+" is superfluous. "=" works just as well.

Regards,
Fred.

"Cindyt" wrote in message
...
I am trying to figure out how I can use the IF function to identify a word,
such as "Home". If it is true, I need to do a formula on that line of
information. The formula I am using is =+((C2-Criteria)-M2)/60. I cannot
seem to add all this together and make it work. I am using Excel 2003.

thanks!