lundi 4 décembre 2017

If statements in Excel

I am trying to write an if statement to further classify my data by type. Basically the cells currently contain the ID number and tissue type, but i want to figure out a way to insert the tissue type classification into the cell below.

So for example the ID # and tissue type (all in the same excel cell) is written 868686 Skin. And in the cell below, I wrote the formula IF(B2="Skin", "Skin", " ") but because I didn't have the whole contents of the cell (the ID#) included, it didn't find it. So is there a way to say IF B2 contains the word skin, then do this...

thanks.

Aucun commentaire:

Enregistrer un commentaire