IF to determine if numbers are between values

[lyman]

Hello

I'm trying to write an if formula to determine which value should be returned when I have numbers between two values. I now realize I cannot do this just with IF function but I need the formula to calculate as follows:

If the cell has value less than 3000 return 150
If the cell has value between 3001 and 5000 return 300
If the cell has value between 5001 and 10000 return 650
If the cell has value above 100000 multiply value in cell by .09% and return result

I'm using the following formula:

=IF(A2<3000,150,IF(A2>3000,300,IF(A2>5000,650,IF(A2<10000,650,IF(A2>10000,A2*0.009,0))))

Where am I going wrong?

Thanks

 

[Fluff]

How about

=if(a2<3000,150,if(a2<5000,300,if(a2<10000,650,a2*.009)))

 

[lyman]

How about

=if(a2<3000,150,if(a2<5000,300,if(a2<10000,650,a2*.009)))

 

[lyman]

How about

=if(a2<3000,150,if(a2<5000,300,if(a2<10000,650,a2*.009)))

Perfect thanks! Brain not functioning today

 

[Fluff]

You're welcome & thanks for the feedback.

 

[Taul]

These guys were quicker than me, but I'll post my version anyway.

=IF(A2>=100000,A2*0.009,LOOKUP(A2,{0,3000,5000},{150,300,650}))