Thread: how would i get an 'grade point average' using this formula
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
VD VD is offline
external usenet poster
  
Posts: 5
Default how would i get an 'grade point average' using this formula
=CHOOSE(MATCH(B3,{0;59;63;69;72;75;79;82;85;89;92} ,1),"F","D","D+","C-","C",
"C+","B-","B","B+","A-","A")

Or am i being too ambitious
--
VD, mistress in progress
Reply With QuoteReply With Quote