Hello everyone,
Just wondering if I can use IF Statements when creating a formula for the final grade. If so, can you give me an example of the synthax? Is it the same as Excel?
Many thanks,
Pierre
There are no IF statements per se. What calculation do you have in mind?
If test1<90 then score=0 else score=25
With a formula you can do something like the following:
=round(([[test1] ]/100)-0.4,0)*25
You can use such a formula in category totals or manual grade items.
hth
Here is how the formula would work:
with test1 score 95
=round((95/100)-0.4,0)*25
=round(0.95-0.4,0)*25
=round(0.55.0)*25
=1*25
=25
with test1 score 89
=round((89/100)-0.4,0)*25
=round(0.89-0.4,0)*25
=round(0.49,0)*25
=0*25
=0
with test1 score 0
=round((0/100)-0.4,0)*25
=round(0-0.4,0)*25
=round(-0.4,0)*25
=0*25
=0
Try
=round([[grade]|*2,0)/2
So,
=round(8.25*2,0)/2=
=round(16.5,0)/2=
=17/2
=8.5
and
=round(8.24*2,0)/2=
=round(16.48,0)/2=
=16/2
=8.0
A greate trick! Thanks!