I am trying to create a lookup table for a calculator I am creating in excel.
I need the calculator to look up a deration factor based on both the
altitude and the temperature. For instance, if I put in a temperature that
falls in the range of 50 to 60 degrees fahrenheit and a altitude falls in the
range of 0 to 1000 feet, I need excel to tell me that my deration factor is
1.00. However, if I put in a temperature that is above 130 with an altitude
of 3000 to 4000 feet I need Excel to tell me that my deration is 0.98. Is
there a method or formula that would allow me to accomplish this task?