How to set value if there is found some word?

In example: I have column with word .COM
I like to set value in another column if there is found .COM like 20 USD.

Is this possible to achieve IF sentence?