How to write a formula in excel for a range of numbers?

Question

excel

I need a formula for excel, so that when you enter a number in the cell in the range from 1500-2500 in another cell, it gives out one number, from 2501-5000, another, from 5001-9000 the third

Answer 1

I need that when entering a number in cell A1 in the ranges <1500 , >=1501<=2500, >=2501<=3500 in cell B1, it would just give the number 0.2, 0.25, 0.35, respectively

Answer 2

It's better to use incremental nesting:
=IF(A1<=1500,0.2,IF(A1<=2500,0.25,IF(A1<=3500,0.35,A1/10000)))

Answer 3

Old of course, but may be useful to someone. It is much easier and clearer to use the "view" function, rather than a bunch of "if" attachments. The only thing is that the list must be sorted in ascending order and the lower limit must be specified.
=LOOKUP(A1;{-10000000000000;1501;2501;3501};{0.5;2.5;3.5;"OUT OF RANGE"}) .