Hello Stefan,
I haven't found an easier solution yet. I use this formula in a course with three tests where the student has to obtain a grade higher than 70 for every single test. The coursegrade will be 0 if one of the results is under 70. 'floor' rounds of to the integer just under a number, so with a score of 60 floor(60/70) is 0 an with a score of 75 floor(75/70) is 1.
=(floor(T1/70))*(floor(T2/70))*(floor(T3/70))*average(T1;T2;T3)
The square brackets got lost... this is how the formula looks:
