Issue on overall rating calculation

Summary:

Content (please ensure you mask any confidential information):

Hello experts,

we have a rating model in place with the following values: 1,2,3,4

The overall manager rating section return the average of competencies and goal evaluations. However, we need to apply the following logic:

If overall average manager rating is between 1 and 1.49 the rating should be 1, if the overall average manager rating is between 1.5 and 2.69 it should be 2,

if the overall average manager rating is between 2.7 and if the overall average manager rating is between 3.5 and 4, it should be 4.

How can I implement this logic?

Thanks in advance for your help!