Hedley Finger wrote:
I scarcely ever use spreadsheets and then mainly for add-ups, take-aways, goesintos, and how many's.I am grading assignments. There is a 5 percent penalty per day for late submission. So I want to subtract the deadline date from the actual submission date, and if the answer is positive, calculate 5 percent of the grade and subtract that value from the grade.I can do most of it if I drink a gin or two. But the tricky bit is "So I want to subtract the deadline date from the actual submission date, and if the answer is positive". Can anyone tell me how to do a conditional branch on the result of the subtraction (or take-away, for those of you who only understand the higher maths)?Regards, Hedley -- Hedley Finger
Actually it is simple. Say the deadline date is in cell A2. Put the date submitted in cell A1. Subtract "=A1-A2" (without the quotes) in cell A3. In cell A4 put in the equation
"=IF(A3>A2; 0.05;"")" (Without the start and end quotes). I have attached a sample Calc spreadsheet to illustrate and get you started. Joe Conner, Poulsbo, WA USA
HEDLY.ods
Description: application/vnd.oasis.opendocument.spreadsheet
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
