Sry... forgot to add the fixed one:
=SI(B4>A4;C4*(1-((B4-A4)*0.05));C4)
2008/10/27 Ely Schoenfeld <[EMAIL PROTECTED]>
> Hi.
>
> Just wanted to say that this formula doesn't work as you expect.
>
> Look bellow.
>
> 2008/10/22 Michael D. Roush <[EMAIL PROTECTED]>
>
>> Hedley Finger wrote:
>>
>>>
>>> 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)?
>>>
>>
>> My suggestion would be to start with the following four columns (plus
>> additional columns for other information not necessary for this
>> calculation). Those four columns are:
>> (A) Date Due
>> (B) Date Submitted
>> (C) Assignment Score
>> (D) Actual Grade
>>
>> Date Due and Date Submitted cells should be formatted as Date (with
>> whatever format you prefer).
>>
>> "Assignment Score" should be formatted for whatever the grading point
>> scale is. This doesn't have to be a percent, but you might use that for
>> consistency.
>>
>> Assuming the column letters I've given above, and that the data starts in
>> row 2, the formula for "Actual Grade" would look like this:
>>
>> =IF(B4>A4;C4-((B4-A4)*0.05);C4)
>>
>
>
> Lets give a numeric example, where an 8 scored homework was submitted ONE
> day late.
> That would give us a final grade of 8*(1-0.05)=7.6 (right?)
>
> A=Oct 10, 2008
> B=Oct 11, 2008
> C=8
> D=IF("Oct 11, 2008">"Oct 10, 2008";8-(("Oct 10, 2008"-"Oct 11,
> 2008")*0.05);8)
> D=IF(true;8-((1)*0.05);8)
> D=8-((1)*0.05)
> D=8-(0.05)
> D=7.95
>
> Wrong... it should have multiplied the grade by the percentage, not
> subtracted it
>
> Hope it helps.
>
>
>
>>
>> What this does is... "If the Data Submitted is higher than (after) the
>> Date Due, subtract five percent from the assignment score for each day the
>> assignment is past the due date."
>>
>> You have to use the IF function if you allow yourself to record an
>> assignment turned in before the due date. Without the IF condition, there
>> would be a 5% bonus for every day early an assignment was turned in.
>>
>> Also, this formula does not take into account whether a day is a "school
>> day" for purposes of calculating the penalty. In other words, an assignment
>> turned in one week late is penalized for seven days, not five. This means
>> an assignment due on Friday and turned in the following Monday gets docked
>> 15%, not 5%.
>>
>> A slightly more complex formula could remove penalties for Saturdays and
>> Sundays.
>>
>> Michael
>>
>>
>>
>>
>>
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: [EMAIL PROTECTED]
>> For additional commands, e-mail: [EMAIL PROTECTED]
>>
>>
>
