Range of numbers with required result

[doylzer]

Hi All,

Hope you can help me out.

I have attached an excel that I'm working from.

What i would like, is to be able enter a number into B2 and in B3 get the corresponding result from F2:F9.

However the number i enter in B2 will need to find th range it fit in (eg E3 =1,200-1,499)
in my example 1,650 would fall in the range of E4 and i want to return 240.


Hope this is all clear..

[TMS]

It would be something like:

Please Login or Register  to view this content.

However, you need to remove the + sign from the 2500+ value and just leave it as 2500.

And you'll need to add a lower limit, say 0, to be applied to values less than 1000


Regards, TMS

[TMS]

Thanks for the rep