How to Combine 2 Formulas into 1?

[honeybee99]

Sector 1: TPE-MFM; Origin 1: TPE; Destination 1: MFM; Route 1: ?
Sector 2: ICN-KUL; Origin 2: ICN; Destination 2: KUL; Route 2: ?
Sector 3: AUH-ICN; Origin 3: AUH; Destination 3: ICN; Route 3: ?

Hi all, I would like to combine 2 excel conditions into a formula, the rationale is:
-If neither "Sector", "Origin" nor "Destination" consists "ICN", show "Route" as "UND"
e.g. TPE-MFM, Route=UND

BUT

-If "Sector", "Origin" or "Destination" consists "ICN", show "Route" as the remaining text, i.e. the non-ICN text
e.g. ICN-KUL, Route=KUL
e.g. AUH-ICN, Route=AUH

Thank you so muchhhhh!

[kersplash]

You would be better attaching a sample workbook, with a mock-up of what you expect as your result for that sample.

Go Advanced -> Manage Attachments -> Upload