View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bob1023 Bob1023 is offline
external usenet poster
 
Posts: 1
Default How do I assign numerical values to a letter? Ex: A = 4, B=3, etc

I'm trying to do a spreadsheet function where I need to assign numerical
values to a letter. Like calculating your collge GPA. A = 4, B=3, C=2, D=1,
F=0. Can I do that?