Hi I have a question that might be simple, I need cell B1 to give me an factor based on where the number in A1 is in a range. My range looks something like this...

Start Stop Factor
1000 2000 1.04
2000 3000 1.08
3000 4000 1.12
4000 5000 1.16
5000 6000 1.2
7000 8000 1.24

So if A1 was 2313 B1 would return 1.08. Is this something simple to do?