Changing numbers/percentages to letter grades
here you go try this
=IF(A6="","",IF(A689,"A",IF(AND(A6<90,A679),"B", IF(AND(A6<80,A669),"C",IF(AND(A6<70,A659),"D",IF (A6<60,"F",""))))))
--
-John Northwest11
Please rate when your question is answered to help us and others know what
is helpful.
"Preston Steele" wrote:
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?
|