Condtional IF confusion

[Kitteridge]

Hello, I wonder if you could help. I am doing some genotyping and am recording the genotype as C/C, C/T or T/T in an excel workbook. I want to automatically generate the phenotype (ie wild type, mutant or double mutant) and am getting bogged down trying to do it. At the moment I am doing it manually, but I am sure that this can be done automatically.

I have tried =IF(I2=C/T,"mutant")but this is no good. I think that it should be easy, but am floundering here

Thanks for your help.

 

[lenze]

Try
IF(I2="C/T","mutant",IF(I2="T/T","Double Mutant","Wild Type"))

 

[Kitteridge]

Thanks very much for your invaluable help. My spreadsheet is now a dream to work with.