Characters in logical calculations
 

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


--
alex3867
------------------------------------------------------------------------
alex3867's Profile: http://www.excelforum.com/member.php...o&userid=37220
View this thread: http://www.excelforum.com/showthread...hreadid=569825

Characters in logical calculations
 

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


--
robert111
------------------------------------------------------------------------
robert111's Profile: http://www.excelforum.com/member.php...o&userid=31996
View this thread: http://www.excelforum.com/showthread...hreadid=569825