I need a formula in excel that identifies ranges, ex
0-30 = 20%
31-60 = 98,5%
61-90 = 100%
91-120 = 101,5%
If f2<= 30 inform 20%; if f2>30 and <60 inform 98,5% , etc.
How do I do it?
what formula do I do for ranges of values in excel?
3
asked by anonymous 07.02.2018 / 03:08
3 answers
0
I just did one here, I do not know if it suits what you want to do, but the formula works in the same way as what was requested.
Formula:
=SE(F2<30;"20%";SE((F2>=30)*OU(F2<61);"98,5%";SE((F2>=61)*OU(F2<91);"100%";"101,5%")))
I hope I have helped!
07.02.2018 / 04:02
0
Use the "SE" function (or "IF" if your office is in English).
This function has the following format:
SE ("condition"; A; B)
where A is the answer if the condition is true and B is the answer if the condition is false.
Example:
SE (F2
07.02.2018 / 13:09
0
If you have Excel 2016, you can use the 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,""
09.02.2018 / 18:27