Excel Formulas Tutorials and Expert Advice

QUESTION

I need calculate a rate of climb for an aircraft. The problem is that I have a different table for different weight. In those tables, the two variables are Temp and Altitude pressure. So depending on the weight, I need to read a specific table and then need to know the temp and Alt Px to find the rate of climb.

ANSWER

It sounds like you need to combine an IF function with a vlookup function.

Something like this...

=if(weight=a,vlookup(value, in table A),vlookup(value,in table B))

The if function excepts three parameters:

1. A condition (in your case the weight of the aircraft)
2. What to return if the condition is true (in your case it is the value of 'temp' from the first table - use the vlookup() function to get that)
3. What to return if the condition is false (in your case it is the value of 'temp' from the second table - use the vlookup() function to get that)

You'll need to create 2 formulas one for figuring out the Alt Px value and one for the 'temp' value.