To determine which student gets a "bonus" mark of 5, a GRAD student must be PRESENT in both SEMINARS.
An undergrad student, UGRAD, must have been present in either SEM 1 or SEM 2.
If a grad student had attended on one or no seminars, bonus=0. If an ugrad student attended none, bonus=0.
I came up with formulas for both undergrad, ugrad and for grad students but am having difficulty combing the functions into one as required.
for GRAD I used:
for UGRAD I used:
** EDIT only one formula may be used