# IF formula help

#### gudzxo

##### New Member
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
maybe this?
=if(count(B2:C2)>0,5,0)

#### gudzxo

##### New Member
doesn't work unfortunately but thanks

#### FDibbins

##### Well-known Member
Then show some sample data

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

#### gudzxo

##### New Member

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
Hi,

 EnrollNo Degree S1 S2 Score 101 Graduate 1 0 0 102 Undergraduate 0 1 2 103 Graduate 1 1 2 104 Graduate 1 1 2 105 Graduate 0 0 0 106 Graduate 1 1 2

<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

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

#### gudzxo

##### New Member
I'm getting #VALUE! when i use this formula

#### gudzxo

##### New Member
Instead of the numbers 1 and 2 under S1 and S2 , I have present and absent

#### FDibbins

##### Well-known Member
Where is your sample data, or should we all just keep guessing?

Did you miss this post?

Replies
10
Views
506
Replies
13
Views
136
Replies
2
Views
93
Replies
2
Views
603
Replies
10
Views
198

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

### 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.

### Which adblocker are you using?

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

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