Home > Tutorials > Excel Markbook
Since I wrote these notes I have learnt a few new things about using the Vlookup formula
1) You can place the vlookup table on a separate worksheet and reference it from within the formula using the name of the worksheet
2) If you place the vlookup table on a separate worksheet you don't have to state the upper left and lower right cell numbers in the formula
The result of this becomes a formula that looks like the following:
I saw your website about an Excel markbook, I'm starting to make my own and I have a query you might be able to help with.
I have attached the sheet.
I want to be able to enter "Abs" when students miss an assignment legitimately and have it not affect their term average or grade.
Do you have any idea how I can achieve this?
=ISNUMBER(A1) will return TRUE of FALSE
=IF(ISNUMBER(H5),(H5/$H$4)*100,0)+IF(ISNUMBER(I5),(I5/$I$4)*100,0) The trick is to use a sequence of if commands IF(ISNUMBER())
Markbook Excel 13 KB created 19 June 2014
Excel Markbook PDF File 855 KB
CorelDraw10 file 476 KB
Markbook Excel 41 KB
Markbook ACU gradings 14 KB xlsx file
updated 25 November 2014 thanks to Amber Van Dreven for poiniting out an issue with rounding of grades
Markbook Excel 9 KB
Russell, R. (2018, November 14, 12:02 pm). Excel markbook example.
Retrieved December 19, 2018, from http://www.rupert.id.au/tutorials\markbook/index.php
Last refreshed: December 19 2018. 11:35.06 pm
This work is licensed under a Creative Commons Attribution-NonCommercial-ShareAlike 2.5 License.
10564 visits since July 26, 2006