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