making a spreadsheet for student coursework making

i am making a spread sheet table to auto decide whether a piece of coursework is late and who to decide how much penalty to allocate

i have got the total mar in percentage

the submission date for each student

deadline date

each student is allowed up to 3 weeks to be late each week being a 10% penalty and a total mark of 0 after the 3rd week.

i can email you what i have come up with so far any advice would be welcome

thank you

Hi

Can you please attach the sample file, what is your data and what you want?

for more details.

Rahul

How will you be getting the send and due date?

i have attached a file for reference using dummy data

Originally Posted by Jack in the UK

How will you be getting the send and due date?

Ok i see the submission date --

Due date ????

I am also searching for due date

Originally Posted by Rahul Nagar

I am also searching for due date

Ditto - have to wait for the Original Poster guess

its at the top of the spreadsheet "assessment deadline date" "05/05/2009"

Sheets 1, Cell G1 ...

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.

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

im not too sure how the if function works.

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

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.

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

works perfectly
thanks allot sorry about the repost couldn't find the original thought it got deleted.

now i need to try and figure out how to get the grade column to work.