formula for within table range

[alizok]

Hello everyone

I have a table, I need a formula that look thru this table and if the number does not fall within this table than do additional formula otherwise display results. for example I have table like this:

128 - 132 = 50%
144 - 148 = 75%
160 - 164 = 100%

In this case if the data equal to 144 the result should be 75% if the data is 146 = 75%, if the data is 129 = 50% but if the data is 165 then it should preform different calculation and the result should be equal to 105%. Basically firs the formula looks within the table if it's within table range it just display the results. If the data is outside of the table ranges then it should to interpolation formula.

EDIT:
just to be clear here if the data is at 149 the result should be 80%. I know how to do interpolation formula I just need a formula that will be able to identify if the data falls within the range that I have in the table if not then do different formula.

 

[Eric W]

Something like this?

=IFERROR(LOOKUP(A1,{128,133,144,149,160,165},{50,"a",75,"a",100,"a"})/100,"other formula here")

 

[alizok]

Wow... that's was easy. Thank you very much it worked like a charm.

 

[Eric W]

You're welcome.