# Temperature / Humidity Correction Factor

Question asked by james.arackal on Oct 26, 2017
Latest reply on Aug 24, 2018 by bbregenzer

Hi ,

I'm trying to lookup / Calculate an interpolated correction factor in AF from Temperature / Humidity input Table.

The table looks as follows in Excel.

Input 1  : Ambient Temperature

Input 2  : Relative Humidity

Required Result : Interpolated Lookup for Blue font values

Can any one guide how to do this ?

 Ambient Temperature -  Deg. C Relative Humidity-Percent 15 20 25 30 35 40 45 51 0 1.00 1.00 1.01 1.03 1.06 1.10 1.13 1.12 10 1.00 1.00 1.01 1.03 1.06 1.10 1.14 1.12 20 1.00 1.00 1.02 1.03 1.06 1.09 1.13 1.12 30 1.00 1.00 1.02 1.03 1.04 1.07 1.09 1.10 40 1.00 1.01 1.01 1.02 1.03 1.05 1.06 1.06 50 1.00 1.00 1.01 1.01 1.02 1.02 1.03 1.03 60 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 70 1.00 1.00 0.99 0.99 0.98 0.98 0.97 0.97 80 1.00 0.99 0.99 0.98 0.97 0.96 0.94 0.95 90 0.99 0.99 0.98 0.97 0.95 0.94 0.92 0.92 100 0.99 0.98 0.97 0.96 0.94 0.91 0.89 0.89