Dear Friends,
I am having a problem with excel formulas and need your help in this regard. Though I have got most of the formula, I just need some help to further structure it.
I am making a grade sheet and need to generate GRADES from MARKS. In the MARK LIST the following numbers / alphabets can be seen
25,45,85,65,65,and numbers which are the marks obtained.
AB is marked wherever ABSENT is there.
and in some places instead of marks directly the GRADES are entered, like S, A, B, C, D, and F.
So in the file the MARKLIST and GRADELIST are side by side columns, and GRADESHEET
COLUMN is used to display the grades as per the formulas entered for the specific mark ranges which are as follows
If MARKS are GRADE
less than 50 F
50-54 D
55-64 C
65-74 B
75-84 A
85 and above S
and wherever blanks are present the GRADESHEET should display BLANK,
wherever alphabets / Grades are alredy entered in marksheet the Gradesheet should display them as it is.. for.eg. if in marksheet AB is there same should be displayed in Grade sheet.
I have solved the numbers / numerical marks case, need your help with the Alphabets wherever the letters are used i.e A,S, D,C, or AB etc.
Please help me to modify the formula. The current formula is
=IF(B21>84,"S",IF(B21>74,"A",IF(B21>64,"B",IF(B21>54,"C",IF(B21>49,"D",IF(AND(B21>0,B21<50),"F",B21))))))
I can also forward u the file as sample, for that kindly mail to (email deleted by mod) or file attached herewith as sample.
THANKS IN ADVANCE ..
You can also mail me the solution on (email deleted by mod) or reply to this post as per your convenience.
RAVI
Bookmarks