View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
JDSkiing JDSkiing is offline
external usenet poster
 
Posts: 2
Default In Excel can I make a letter value equal a specific number

For example, If I wanted every time the letter F was input as data that,
within the fields marked that F would equal the number one, then for example
G would equal 1.5, so that if a row had three F's and 2 G's it would equal 6
if I totalled the row across. This is a simple xample of what I am trying to
accomplish, but if someone can show me this I can figure out the rest.
Thank you
James Deutschkron