IF cell A1 contains "X", enter "X" in cell B1, if not enter "Y" HE

[adre77]

The operation I am trying to do is:
If cell A1 contains the word "AMR", I need Excel to show in cell B1 the word
"AMR", if it does not find it, enter the word "Other". The word ‘AMR’ will
not be always in the same position in other cells, it can be located anywhere
(at the beginning, somewhere in the middle or at the end) on the cell.

I tried doing it this way: =IF(A1=*"AMR"*,"AMR","Other")
but I got an error message.

Does anyone know a formula or another way Excel can do this operation?

Any insight would be greatly appreciated.

 

[Lars-Åke Aspelin]

The operation I am trying to do is:
If cell A1 contains the word "AMR", I need Excel to show in cell B1 the word
"AMR", if it does not find it, enter the word "Other". The word ‘AMR’ will
not be always in the same position in other cells, it can be located anywhere
(at the beginning, somewhere in the middle or at the end) on the cell.

I tried doing it this way: =IF(A1=*"AMR"*,"AMR","Other")
but I got an error message.

Does anyone know a formula or another way Excel can do this operation?

Any insight would be greatly appreciated.

Try this formula:

=IF(ISERROR(FIND("AMR",A1)),"Other","AMR")

Hope this helps / Lars-Åke

 

[adre77]

Thanks for the formula Lars-Ã…ke. I have another question:
what if instead of showing the word "other" I need Excel to do another if
statement...Let me explain:
in Column A i have the following:
Reject-AMR & Billing
Check-AMR & Billing-
Billing-Meter Read
Billing-AMR & Check-AMR
Check-Download & Billing- Gas
what i need now is: if it says AMR, show AMR, if it says Meter Read, show
Meter Read, if it says Download, show Download... how can i do this? I am
trying to do several if statements with the formula you sent me, but I can't
seem to find the right formula

-thanks in advance!