IF formula help

gudzxo

New Member
Joined
Dec 2, 2016
Messages
6
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
 

Excel Facts

How can you turn a range sideways?
Copy the range. Select a blank cell. Right-click, Paste Special, then choose Transpose.

FDibbins

Well-known Member
Joined
Feb 16, 2013
Messages
6,723
Then show some sample data

And what does "doesn't work" mean? wrong answer? no answer? something else?
 

gudzxo

New Member
Joined
Dec 2, 2016
Messages
6

ADVERTISEMENT

wrong answer because it does not indicate for whether it is a grad or undergrad student or if they have been present or not
 

Anand Sharma

Board Regular
Joined
Nov 22, 2016
Messages
63
Hi,

use the below formula I sure It will help you

=IF(AND(B3="Graduate",C3+D3>1),2, IF(AND(B3="Undergraduate",C3+D3>0),2,0))

EnrollNoDegreeS1S2Score
101Graduate100
102Undergraduate012
103Graduate112
104Graduate112
105Graduate000
106Graduate112

<colgroup><col><col><col span="3"></colgroup><tbody>
</tbody>

Its checking first for Graduate then Seminar attended or not else undergraduate seminar attended or not
 

FDibbins

Well-known Member
Joined
Feb 16, 2013
Messages
6,723

ADVERTISEMENT

Where is your sample data, or should we all just keep guessing?
 

gudzxo

New Member
Joined
Dec 2, 2016
Messages
6
Instead of the numbers 1 and 2 under S1 and S2 , I have present and absent
 

Watch MrExcel Video

Forum statistics

Threads
1,130,048
Messages
5,639,769
Members
417,111
Latest member
buyukbang

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top