# 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

If Excel says you have links but you can't find them, go to Formulas, Name Manager. Look for old links to dead workbooks & delete.

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

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

1,164,438
Messages
5,837,240
Members
430,487
Latest member
michaeltusi

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