I got to admit I'm getting a little off edge with these tables, so since I already have a former post of an excel table I won't get into much detail. I used the formula:
=IF(MIN(B4:D4)<5, "failed", AVERAGE(B4:D4))
Things are simple if you want to calculate the interpose of someone use the formula, the only thing that's changed is that rather then saying "passed" "failed" it shows you the interpose, and if the student failed then it obviously shows "failed". There is really no need to get into much details, just use that formula, change the data if needed, and look at the image above, it's really simple.
=IF(MIN(B4:D4)<5, "failed", AVERAGE(B4:D4))
Things are simple if you want to calculate the interpose of someone use the formula, the only thing that's changed is that rather then saying "passed" "failed" it shows you the interpose, and if the student failed then it obviously shows "failed". There is really no need to get into much details, just use that formula, change the data if needed, and look at the image above, it's really simple.
Niciun comentariu:
Trimiteți un comentariu