Our school require all students to have 23 credits to graduate. For the students to be in 9

^{th}grade, they must have less than 6 credits. To be in 10

^{th}grade they must have between 6 and 11.99 credits. To be in 11

^{th}grade, they must have between 12 and 16.99 credits. To be in 12

^{th}grade, they must have 17 or more credits.

The problem is when we receive transferred students who have attended other high schools, their graduation requirement might be higher. So if the transferred student needs 24 credits to graduate then she must have less than 7 credits to be in 9

^{th}grade, between 7 and 13.99 to be in 10

^{th}grade …etc.

I need to have an if statement to place all students in the right grade level. In excel 2016 sheet I have 17 columns: Column C has the grade level, column N has the total credits the students earned so far, column O has Graduation Requirement (23 or higher). I need to place the If statement in column C to show the correct grade level.

Please see example below:

Column A | Column B | Column C | Column N | Column O | |

State ID | Name | Grade | Total Credit | GradReq | |

10 | 11.75 | 23 | |||

10 | 7.5 | 24 | |||

12 | 20.5 | 24.5 | |||

10 | 10.65 | 23.4 | |||

11 | 17.05 | 23.8 | |||

9 | 7.7 | 24.75 | |||

12 | 22.5 | 27.5 | |||

11 | 20 | 27 |

<tbody>

</tbody>