Good morning all,

I am trying to make a Percent with in Limits (PWL) calculation. I am
stumped on how to make a formula for it. Here is a sample

ie: % With in Limits
test 100 99 98 97 96 .......
11 0.9 0.8 0.6 0.3 0.1
12 1.8 1.7 1.5 1.3 1.0
13 2.9 2.8 2.4 2.2 2.1

Test #12 find number 1.33 Return value of: 97.15

Manual Calculation is: (((98-97)/(1.5-1.3)) *((1.33-1.3)))+97=97.15

Can anyone please help me?

Eric