IF formula help

[gudzxo]

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

 

[gudzxo]

Status	Seminar 1	Seminar 2	Bonus
grad	present	absent
grad	present	present
ugrad	absent	absent
ugrad	present	present
ugrad	present	absent
ugrad	present	present
grad	absent	absent
ugrad	present	absent
ugrad	absent	present
ugrad	absent	absent

<colgroup><col width="64" span="4" style="width:48pt"> </colgroup><tbody>
</tbody>

 

[FDibbins]

Thank you, that makes things much easier to understand.

	A​	B​	C​	D​
1​	Status	Seminar 1	Seminar 2	Bonus
2​	grad	present	absent	0
3​	grad	present	present	5
4​	ugrad	absent	absent	5
5​	ugrad	present	present	5
6​	ugrad	present	absent	5
7​	ugrad	present	present	5
8​	grad	absent	absent	0
9​	ugrad	present	absent	5
10​	ugrad	absent	present	5
11​	ugrad	absent	absent	5

D2=IF(A2="Grad",IF(COUNTIF(B2:C2,"present")<2,0,5),IF(COUNTIF(B2:C2,"present")>0,5,5))
copied down

 

[FDibbins]

Formula adjusted so you can copy it down past your last row of data...
=IF(A2="","",IF(A2="Grad",IF(COUNTIF(B2:C2,"present")<2,0,5),IF(COUNTIF(B2:C2,"present")>0,5,5)))