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

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

So far this is the best i can come up with.....


=IF(ISNUMBER(AND(FIND("*VA*",O2),FIND("*FHA*",O2)) ),"something",IF(ISNUMBER
(FIND("*VA*",O2),VA, etc etc)

but this doesn't work


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

YAY I GOT IT....

=IF(AND(ISNUMBER(FIND("FHA",O2)),ISNUMBER(FIND("VA ",O2))),"something",
"something else")

thanks anyways


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

gosh i feel so smart when i have a formula like this...

=IF(AND(ISNUMBER(SEARCH("FHA",O2)),ISNUMBER(SEARCH ("VA",O2))),"FHA/VA",IF
(ISNUMBER(SEARCH("FHA",O2)),"FHA",IF(ISNUMBER(SEAR CH("VA",O2)),"VA",IF(OR
(ISNUMBER(SEARCH("conforming",O2)),ISNUMBER(SEARCH ("zero",O2))),"NON_CON",IF
(OR(ISNUMBER(SEARCH("GOVT",O2)),ISNUMBER(SEARCH("3 0K",O2))),"FHA/VA","CONV")))
))

hehehe like i actually accomplished something today


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

FIND is case sensitive, you may be better off with SEARCH:

=IF(AND(ISNUMBER(SEARCH({"FHA","VA"},O2))),"someth ing","something else")

--
HTH

Sandy

Replace@mailinator with @tiscali.co.uk


"Derek Y via OfficeKB.com" wrote in message
...

YAY I GOT IT....

=IF(AND(ISNUMBER(FIND("FHA",O2)),ISNUMBER(FIND("VA ",O2))),"something",
"something else")

thanks anyways


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