AutoHotkey | Android | Arduino | COMM140 | Fractals |** **Grammar Checkers | Knots | A Million Dots Activity | Processing | **Processing for Scratch Users** | **RedBubble** | **Tutorials** | Weather | World Time Meeting Planner | Favicon Generator.

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:

**=VLOOKUP(G2,Table!$A:$B,2,TRUE)**

Hello Rupert,

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.

i.e. only average the five assignments that Fred has completed and ignore the missed one.

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

APA citation:

Russell, R. (2019, May 24, 11:17 pm). *Excel markbook example.*

Retrieved October 21, 2019, from http://www.rupert.id.au/tutorials\markbook/index.php

Last refreshed: October 21 2019. 02:41.25 pm

This work is licensed under a Creative Commons Attribution-NonCommercial-ShareAlike 2.5 License.

** 11305 ** *visits since July 26, 2006*