IF function + a formula
Are you trying to find Home in the text contained in a single cell (Fred
gave you code which should do that) or are you looking for the word Home in
a column of data? Assuming the latter..
=IF(ISNUMBER(MATCH("Home",A1:A100,0)),(C2-Criteria-M2)/60,"")
--
Rick (MVP - Excel)
"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!
|