View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Teethless mama Teethless mama is offline
external usenet poster
 
Posts: 3,718
Default Need (Excel) formula to make Mark sheet with Automatic Grading

Try this:

=LOOKUP(C2,{40,50,60,70,80,90},{"F","E","D","C","B ","A+"})



"Need Formula for Mark Sheet" wrote:

A B C D
SL. # Subject Marks Grade
1 English 96
2 History 58
3 Math 46
4 Chemistry 66
5 Physics 72
6 Urdu 85
7 Oncology 82
8 Biology 91
9 Drawing 57
10 Extra 89
11 HIJ 55
12 ABC 81
13 XYZ 49
14
15
so on so on


Marks Range Grade
90+ A+
80 TO 89 B
70 TO 79 C
60 TO 69 D
50 TO 59 E
40 TO 49 F


I want that when I put marks in Marks Columns i.e. C, Grade will be appear
automatically as per above mention range.

Please send me formula to apply. Looking forward for prompt and favorable
response.

Thanks and Regards
Hina