Interpolate (formula)

[Jarvin24]

Hi Team,

I was wondering if someone could help me with a formula.

Explanation:

I have a table with 2 main parts (SOUND VALUE and TRIM VALUE). The concept is basically if there was a given SOUND VALUE and TRIM VALUE, all I have to do is to find where the values intertwined.

Table.jpg

The next problem is, if the Sound Value given is more than the base value on the table. On this case, I would have to compute for the difference. (kindly see attached file for sample computation.

Hope for your assistance.

^_^

[AliGW]

In B20:

=LOOKUP(B18,$A$3:$A$8)+(((B18-LOOKUP(B18,$A$3:$A$8))/5)*(INDEX($B$3:$H$8,MATCH(B18,$A$3:$A$8,1)+1,MATCH(B19,$B$2:$H$2,0))-INDEX($B$3:$H$8,MATCH(B18,$A$3:$A$8,1),MATCH(B19,$B$2:$H$2,0))))

[bakerman2]

WOW Ali, you must already had your coffee yet because coming up with this this early in the morning.

[Jarvin24]

Hi Ali,

Wow.. Just wow!! Thank you so much.. I'll have to understand this formula...

Regards,

[AliGW]

You're welcome, Jarvin!

Rudi - yes, I had already had my coffee, but it's just an equation at the end of the day.