View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
jk101133 jk101133 is offline
external usenet poster
 
Posts: 1
Default How do I set up a formula to calculate a letter as a value

I am trying to set up a formula that will take a character entered such as
"N" and then get it to change the "N" in to a weighted percentage. So for
example if I asked a question and the person's choice for response is Yes,
No, NA and they selected No or N the next column would represent that N or No
as .15