Derek Y wrote:
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(???)


I know i wasn't very specific but if you can help with this i will be able to
figure out the rest for my more complicated function.


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