Hi all,

Hopefully someone can tell me what function I should use to determins
whether a cell contains the text "(FX)" to be used in an IF statement. E.g.

In cell A1 I have "ABC Corporation (FX)", in cell A2 I have "ABC
Corporation" and in Cell A3 I have "ABC (FX) Corporation". In cells B1 to
B3 I want a formula that returns TRUE in B1 and B3 and FALSE in B2.

Thanks in advance.

Cheers,

Andrew