Hi guys,
I am currently marking exam papers and recording results in Excel. I have formulas set up to work out percentages etc, but want to insert a formula to determine what level each paper has achieved (for example, if students scored less than 11 marks = level 3, between 11 & 30 = level 4, over 24 = level 5 etc). I have attempted to use the 'If' function (with no success!) but cant work out to do it.
Can anyone help?
Muchos thanks!
- It is currently 21 May 2013, 08:03 • All times are UTC + 1 hour [ DST ]
Excel help!
4 posts
• Page 1 of 1
Re: Excel help!
by Echo » 22 Sep 2012, 21:53
Not that anyone is remotely interested, but I've cracked it!
-
Echo - Problem Solver
- 29/Male/United_Kingdom
- Posts: 7364
- Joined: 24 Aug 2005, 16:37
Re: Excel help!
by [ben] » 20 Oct 2012, 23:00
Sorry, only just seen this.
I use spreadsheets to convert raw marks to grades/levels ALL the time. I think the best way to do it is to create a table as use VLOOKUP (or HLOOKUP, for that matter)
I use spreadsheets to convert raw marks to grades/levels ALL the time. I think the best way to do it is to create a table as use VLOOKUP (or HLOOKUP, for that matter)
-
[ben] - dere n ara deg ata i
- 30/Male/
- Posts: 5464
- Joined: 28 Jun 2004, 02:32
4 posts
• Page 1 of 1
Who is online
Users browsing this forum: No registered users and 1 guest