AND IF OR rule

[bibekpd]

Hi,

I am doing my coursework and ive got to this point where i cannot get past this problem.

1. A small file of student records for 26 students is given at the end of this document. The format of each record in the file is: Name, Coursework 1 mark, Coursework 2 mark, Coursework 3 mark, Part 1 Exam mark, Part 2 Exam mark. All of these numbers represent percentages.
2. Load the student records into a spreadsheet by first saving them into a text file (copy and paste it into Notepad, and then Open that file within Excel).
3. Add a column called CW Average giving the student's overall coursework average.
4. The contribution of each of the five marks in each student record to the overall course average is: Coursework 1(10%), Coursework 2(10%), Coursework 3(20%), Part 1(20%), Part 2 (40%). Add a column called Total giving the students' overall course average.
5. A student cannot pass CSC6001 if they achieve an average of less than 35% for the coursework. Add a column that shows the Returned Mark for the course. Provided that the student has achieved a coursework average of 35% or more, then the Returned Mark is simply the student's overall course average. However, if they do not average 35% for the coursework, then the maximum returned mark is 35%. In this case, if their overall course average is more than 35%, then the Returned Mark is 35%.
6. Add a column called Class that displays the equivalent Honours degree classification for each student's Returned Mark (i.e. F, III, 2.II, 2.I, 1)
7. Produce a chart showing the number of students in each degree class. Place the chart on an appropriately named worksheet.
8. Add a row giving the average for each of the numeric columns.

My problem is number 5. I cannot get it to recognize %'ages so i cannot use =if(E2.... and so on..can some one help me how do i interpret number 5 in a rule.

Thanks.

[NBVC]

=IF(E2=35%... or =IF(E2=0.35

both check that E2 is 35% or not.

[scottylad2]

It's probable the cell you wish to display the % in is already taking the formating from an adjacent cell, try clearing all formats from it using the format eraset then format it before putting in your formula, say percentages showing 2 places after the decimal then input your formuls

[bibekpd]

=IF(E2=35%... or =IF(E2=0.35

both check that E2 is 35% or not.

thanks for the reply.

But on the task IF its greater than 35% then whatever the result is and if its less than 35% then 35% would appear on teh field ? so shouldnt it be =IF(E2>35%,"E2","35%") but then that rule doesnt work -_-

[NBVC]

Don't use quotes when referencing numbers or cells..

e.g

=IF(E2>35%,E2,35%)

You may need to also format the cell so that it displays percentages...

[bibekpd]

Don't use quotes when referencing numbers or cells..

e.g

=IF(E2>35%,E2,35%)

You may need to also format the cell so that it displays percentages...

thanks..problem solved