Get the values based on Criteria

[Vijayonline2008]

Have an excel sheet in which the data is there from A2 to A1000. First two entries are

given below.


15682

124000


In B Column i must get the value based on these two criteria

Between 15000-20000 value should be 250

Between 100000 to 150000 value should be 950


In the above example we should get like this with formula . Is there any way to do this.

15682 250

124000 950

 

[SirJB7]

Hi, Vijayonline2008!

Try this:

=IF(AND(A2>=15000,A2<=20000),250,IF(AND(A2>=100000,A2<=150000),950,""))

Copy down as needed.

Regards!