I'm currently facing an issue. My students must score ≥80% on every topic before they can receive their final grade and a certificate. The final grade is a (non-weighted) average of all topics and must be ≥80%.
I'm currently using =average(1,2,3,4,5,6,7,8,9,10) for the course with ten topics. The problem here is that if a student finishes the first eight topics with 100%, they receive their certificate.
After reading the documentation I found out I should probably use the =if(AND function. But, is it possible to add more than two conditions in this function. And if so, what should be my new formula?
If someone could send me one example of how my formulas should look, that would be great!