View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
robert111 robert111 is offline
external usenet poster
 
Posts: 1
Default 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