Excel si cellule contient texte alors...

Hello,
I have the same issue, except that my "Saturday" comes from a cell that includes a formula that displays "Saturday"

Cell 1 = 13-12-2014 (on Sheet2)
Cell 2 = =IF(Sheet2!A5="","",Sheet2!A5) displays the cell in [$-80C]jjjj
Cell 3 = =IF(COUNTIF(A15,"*Saturday*"),"40","30")

A big thank you if you know how to respond.

Hello, did you try to copy/paste your "Saturday" cell as a value?

I have an issue with the first formula; I would like to retrieve the *NBR* by extracting a string.
For example: I want to go through a list of elements in column A and find out how many times the elements from column B appear.

ssss to complete my question
+COUNTIF($H$12:$H$38,"*"&A1&"*"),
the formula above could meet my need, but "*7*" must be a variable that is retrieved
from a cell.

Just to have a working link

http://www.yvoz.net/2010/09/excel-tester-chaine-caracteres-contient/

=IF(COUNTIF(A1,"*Sunday*"),A2*1.2,"")

Hello Roxane,

I think the answer to your question is the nested conditions as Ricky38 pointed out.
=IF(A1="FRANCE","FR",IF(A1="","",IF(A1<>"FRANCE","INT","")))

As for me, my question would be:

I want to do: IF A1 = "TXT" THEN A2 ELSE 0
And the TXT would be a cell containing a drop-down list. Is that possible?

Thank you in advance!

Response to my own question:
=IF(A1=K1,A2,0)
I had just made the mistake of writing
=IF(A1="K1",A2,0)

Hello,

I am looking for a nested formula that allows me to automatically input the email address based on the first and last names of the recipients...

If you understood me, thank you for helping me :-)

Best regards,

Hello everyone,
I have a problem with Excel as I need to go through each column and check if the content of each cell contains special characters; if so, replace them with normal characters. Please help me.