what Formula do I make for ranges of values in excel?

My answer is a little late, but I hope it will be useful. You could replace the function SE with PROCV, as follows:

=PROCV(c1;A1:B4;2;1);

The table must be assembled as follows:

Note: As you reported integer ranges I am only considering that there will be no decimal numbers (e.g. 30,2 - in this case it would not work).

I just made one here, I do not know if it suits what you intend to do, plus the formula works in the same reasoning as was requested.

Formula:

=SE(F2<30;"20%";SE((F2>=30)*OU(F2<61);"98,5%";SE((F2>=61)*OU(F2<91);"100%";"101,5%")))

Hope I helped!

Use the "IF" function (or "IF" if your office is in English).
This function has the following format:
If ("condition"; a; B)
where A is the answer if the condition is true and B is the answer if the condition is false.

Example:
If (F2 In this case if the content of cell F2 is less than or equal to 30, the formula will return the value 20%, otherwise it will return 100%.

To solve your problem, we must use several times the same Formula, One within the other, as below:

SE(F2<=30; 20%; SE(F2<=60; 98,5%; SE(F2<=90; 100%; 101,5%)))

Notice that case F2

If the result appears as 0.2 instead of 20%, just use cell formatting as percentage (%icon in the formatting bar).

I hope it was clear to response.
Hug.

If you have Excel 2016, you can use the function IFS

=IFS(C1<=30,0.2,AND(C1>30,C1<=60),0.985,AND(C1>60,C1<=90),1,AND(C1>90,C1<=120),1.015,TRUE,"")

Or

=IFS(C1<=30,0.2,E(C1>30,C1<=60),0.985,E(C1>60,C1<=90),1,E(C1>90,C1<=120),1.015,Verdadeiro,""

[

Using the SE function with condition E, you can name the ranges.

Follows the Formula;

=SE(E(B3>=0;B3<=30);$H$3;SE(E(B3>=31;B3<=60);$H$4;SE(E(B3>=61;B3<=90);$H$5;SE(E(B3>=91;B3<=120);$H$6))))

Hope I helped!