View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mike Rogers[_2_] Mike Rogers[_2_] is offline
external usenet poster
 
Posts: 284
Default "A+" convert to "4," "A-" to "3.7" etc...

Kevin

Look up "IF worksheet function" in help and it gives an example of exactly
what you are looking for. ( in XL2K)

Mike Rogers

"Kevin Stone" wrote:

I'm doing a GPA chart and want to have the letter grades entered in one cell
and have the corresponding number in the cell beside it... I'm not asking the
right question so I'm not getting the right answer :-).

Kevin