I want a function that can do this:

IF O2 CONTAINS "ABC" AND "DEF" THEN ABC/DEF, IF O2 CONTAINS ABC and NOT DEF
THEN "ABC", etc etc

is this pssible with IF(search(???)


--
Message posted via http://www.officekb.com