Remember Me?

#11
April 16th 14, 08:39 AM posted to microsoft.public.excel.worksheet.functions
 external usenet poster First recorded activity by ExcelBanter: Apr 2014 Posts: 1
Need (Excel) formula to make Mark sheet with Automatic Grading

On Saturday, 20 September 2008 18:07:10 UTC+5:30, wrote:
Hi,

I agree VLOOKUP; however, the lookup table should be set as follows:

40 F
50 E
60 D
70 C
80 B
90 A+

Alternatively if you want to use a formula the following one can be
placed in D2 and copied down.

=IF(C2=90,"A
+",IF(C2=80,"B",IF(C2=70,"C",IF(C2=60,"D",IF(C2 =50,"E",IF(C2=40,"F","Not

Cheers

#12
April 16th 14, 03:48 PM posted to microsoft.public.excel.worksheet.functions
 external usenet poster First recorded activity by ExcelBanter: Feb 2011 Posts: 3,514
Need (Excel) formula to make Mark sheet with Automatic Grading

Not sure why you're reposting a 6-year old reply, but...

My "GradesTable" is laid out as follows...

ScoreAvg 0 50 55 60 65 70 75 80 90
PointAvg 0.00 0.50 1.00 1.50 2.00 2.50 3.00 3.50 4.00
Grade U D D+ C C+ B B+ A A+

...so it occupies the top 3 (hidden) rows only of my grades sheet, and
is defined with a local scope name.

The formula I use for 'PointAvg' is...

...and the formula I use for 'Grade' is...

...where "TotalMark" is a column-absolute, row-relative local scope
defined name range that collects values in a 'Summary' module from all
course outline modules to arrive at a final 'ScoreAvg' for each student
in the class list.

Note that all defined name ranges use local scope so I can have several
class sheets in the same workbook without name conflicts. The class
sheet is inserted from a template and so all 'like' areas use the same
defined names.

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion

#13
April 17th 14, 12:05 AM posted to microsoft.public.excel.worksheet.functions
 external usenet poster First recorded activity by ExcelBanter: Mar 2011 Posts: 621
Need (Excel) formula to make Mark sheet with Automatic Grading

Enter in D2

=LOOKUP(C2,{0,40.1,50.1,60.1,70.1,80.1,90.1},{"Not

Gord

On Wed, 16 Apr 2014 00:39:29 -0700 (PDT), wrote:

On Saturday, 20 September 2008 18:07:10 UTC+5:30, wrote:
Hi,

I agree VLOOKUP; however, the lookup table should be set as follows:

40 F
50 E
60 D
70 C
80 B
90 A+

Alternatively if you want to use a formula the following one can be
placed in D2 and copied down.

=IF(C2=90,"A
+",IF(C2=80,"B",IF(C2=70,"C",IF(C2=60,"D",IF(C2 =50,"E",IF(C2=40,"F","Not

Cheers

#14
April 19th 14, 08:32 PM posted to microsoft.public.excel.worksheet.functions
 external usenet poster First recorded activity by ExcelBanter: Apr 2014 Posts: 1
Need (Excel) formula to make Mark sheet with Automatic Grading

SUM(C4:G4)
H4/500*100
IF(I4=68,"pass","Fail")
IF(I690,"A",IF(I680,"B",IF(I670,"C","F")))
#15
June 19th 14, 02:38 AM posted to microsoft.public.excel.worksheet.functions
 external usenet poster First recorded activity by ExcelBanter: Jun 2014 Posts: 1
Need (Excel) formula to make Mark sheet with Automatic Grading

On Saturday, 20 September 2008 14:08:00 UTC+5:30, 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

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

B C D MARK GREAD
2 40 49 F 59 E =VLOOKUP(E2,\$B\$2:\$D\$7,3,TRUE)
3 50 59 E
4 60 69 D
5 70 79 C
6 80 89 B
7 90 100 A+

#16
November 18th 14, 10:52 AM posted to microsoft.public.excel.worksheet.functions
 external usenet poster First recorded activity by ExcelBanter: Nov 2014 Posts: 2
Need (Excel) formula to make Mark sheet with Automatic Grading

On Saturday, September 20, 2008 2:08:00 PM UTC+5:30, 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

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

please give formula one student mark sheet view in one class student
#17
November 18th 14, 10:59 AM posted to microsoft.public.excel.worksheet.functions
 external usenet poster First recorded activity by ExcelBanter: Nov 2014 Posts: 2
Need (Excel) formula to make Mark sheet with Automatic Grading

Science
Ram 30
Syam 30
Kally 20

English
Ram 40
Syam 50
Kally 30

Maths
Ram 55
Syam 45
Kally 35

See Details on students Marks summery on click

Ram
Science 30
English 40
Maths 55

#18
February 17th 16, 10:57 AM posted to microsoft.public.excel.worksheet.functions
 external usenet poster First recorded activity by ExcelBanter: Feb 2016 Posts: 1
Need (Excel) formula to make Mark sheet with Automatic Grading

thank you...for most knowldge

 Thread Tools Search this Thread Search this Thread: Advanced Search Display Modes Linear Mode

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post Rajesh M Excel Discussion (Misc queries) 1 September 8th 08 07:55 AM frankmai Excel Discussion (Misc queries) 3 December 14th 05 03:09 AM [email protected] Excel Discussion (Misc queries) 2 October 11th 05 08:57 PM Lelindar Charts and Charting in Excel 1 April 6th 05 03:03 AM BauerY Excel Worksheet Functions 3 March 24th 05 06:34 PM

All times are GMT +1. The time now is 03:35 AM.