View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Preston Steele Preston Steele is offline
external usenet poster
 
Posts: 1
Default Changing numbers/percentages to letter grades

I am trying to create several linked spreadsheets to form a grading system
for class. I have most of the formulas down; however, I am trying to get a
cell that pulls from two other cells (50% for classroom, pulled from another
worksheet and 50% for lab, also pulled from another worksheet, totaled in A6)
that now shows a percentage (87% in A6) to show as a B in cell A7. How do I
do this?