Characters in logical calculations

[alex3867]

I am trying to create the formula which interprets 'y' as 'YES' and 'n' as 'NO' in a set of seperate cells (i.e one column has y's and n's, converted to YES's and No's in another column)

I have tried the IF function, but even with no character (y or n) in the first column, NO is still shown in the second.

Ideally I need a discrete formula that shows only YES or NO only if y or n is present.

Any ideas?

Thanks in advance
Alex

[robert111]

=if(a1="","",if(a1="y","yes",if(a1="n","no","")))