Thread: IF function
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Teethless mama Teethless mama is offline
external usenet poster
  
Posts: 3,718
Default IF function
=IF(CODE(UPPER(H55))69,"Z",(CODE(UPPER(H55))-64)*2)


"KAY" wrote:

What is wrong with the function?
=IF(H55=A,"2",IF(H55=B,"4",IF(H55=C,"6",IF(H55=D," 8",IF(H55=E,"10","Z")))))
Thank you for your help!
Karen
Reply With QuoteReply With Quote