having a difficult time coding a cell value change based on another cell row

Hey everyone,

I was wondering if anyone has any insights to the VBA to do the following:

I have percentage values from C3:Z3. If I change any values in this range, I need a corresponding value to appear in C12:Z12.

For example if I Enter 98% in C3, I need a "5" to appear in C12, however the following is also true:

90%>Target.value>98% would generate a 4 instead of a 5, and
70%>Target.value>90% would generate a 3.

I've been messing with the ElseIf functions but I need help writing these conditions correctly.

Thank You