IF clause causing problem while copying the formula

Hi all, I have a problem. I need a fix of it ASAP. I have created a result sheet of students and it consists grading system also. so for example, I have this data:

excel doubt.png

now BT10 should give C2 grade as you can see, but it is not. the formula is misbehaving in multiple cells (in 2-3 cells) but is giving correct answers in the rest of the columns. What to do? Please help. It has been driving me crazy. I have used relative referencing. Even the cell is picking up the right cell reference in the copied formula but it is not evaluating correct result.

BQ is having normal SUM formula.
Formula in BR4=ROUND(BQ4/6,2), copied all the way down.

Please HELP! Thank you in advance.

Read carefully yellow banner on top of page "HOW TO ATTACH YOUR SAMPLE WORKBOOK:"
Not only screen shot.

it is because ROUND(BQ4/6,2) gives 40.50, this is between categories, and you want 41
so you should use:

Please Login or Register  to view this content.

cheers
Erwin