In this fictitious cross-listed course, there are undergraduate and graduate students. Bonus marks areawarded, based on attendance of course seminars. An undergraduate student get a bonus of five (5)marks if he/she attended Seminar 1 or Seminar 2 (or both). However, a graduate student only gets abonus of five (5) marks if she/he attended both Seminar 1 and Seminar 2. Otherwise, zero (0) bonusmarks are given to that student. Calculate the bonus marks for each student listed.
^how can i make ONE IF formula by combining all this info
^how can i make ONE IF formula by combining all this info