making a spreadsheet for student coursework making

**Jack in the UK** · 11-30-2009, 08:27 AM

Sheets 1, Cell G1 ...

**spartan11chin** · 11-30-2009, 08:37 AM

that's the one. the students have 3 weeks after that to hand work in with a 10% penalty on each late week and there is a limit of 3 weeks after which a mark of 0 is applied.

**Jack in the UK** · 11-30-2009, 09:12 AM

Ok so now add a column and use an IF function to decide the days overdue and apply the penalty

**spartan11chin** · 11-30-2009, 09:22 AM

im not too sure how the if function works.

could you give me a quick example showing me the general format of one please

**spartan11chin** · 11-30-2009, 10:00 AM

i have added a new column that contains the difference between the two dates

i need to know who i would go about using an if function to add the amount of penalty into the next column automatically.

**spartan11chin** · 11-30-2009, 04:01 PM

just can't figure out how to get the penalty to work there

**DonkeyOte** · 12-01-2009, 06:50 AM

Assuming late % to be calculated in G12 onwards

G12: =IF($A12="","",LOOKUP(MAX(0,F12-$G$1),{0,7,14,21,28},{0,0.1,0.2,0.3,1}))
copied down

formatted as %

not entirely sure I followed the date requirements - you may want {0,1,8,15,22} rather than {0,7,14,21,28}

making a spreadsheet for student coursework making

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

Re: making a spreadsheet for student coursework making

Re: making a spreadsheet for student coursework making

Re: making a spreadsheet for student coursework making

Re: making a spreadsheet for student coursework making

Re: making a spreadsheet for student coursework making

Re: making a spreadsheet for student coursework making

Re: making a spreadsheet for student coursework making

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions