How to set value if there is found some word?

**toplisek** · 01-09-2012, 03:41 AM

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?

**Fotis1991** · 01-09-2012, 03:49 AM

Hi

If i understoond well your point,then,
You can try this:

=IF(A1=".COM";".COM like 20 USD.";"")

iS THIS WHAT ARE YOU LOOKING FOR?

**Philb1** · 01-09-2012, 04:01 AM

Hi toplisek
If I understood correctly

=IF(RIGHT(A1,4)=".com",20,0)

You can have whatever you like in the cell & if it ends with .com you will get a result, or a 0 if it's missing. If you don't want the 0, substitute it with ""
Cheers

**toplisek** · 01-09-2012, 06:16 AM

Originally Posted by Philb1

=IF(RIGHT(A1,4)=".com",20,0)

This is correct way. Issue is that it sounds an error when input for this formula.
Excel refuses to show 20 as an error inside function.
What is wrong? Do you have working excel with this function to test input?

**Philb1** · 01-10-2012, 01:32 AM

Hi Topsilek
Have a look at the file attached
Cheers

**toplisek** · 01-10-2012, 05:28 AM

This works. Thanks. Just this. How to set OR between different IF sentences as it is quite complex.
=IF(RIGHT(R3;4)=".com";$W$9;"0");IF(RIGHT(R3;4)=".net";$X$9;"0")

Notice .com and .net