Link to home
Create AccountLog in
Avatar of jwn0111
jwn0111

asked on

excel question

I have several aircraft and need to use a curve to add value based on the number of flight hours remaining until overhaul.  The value to add is not linear.  I've put in the data and made a chart in excel, but don't know how to get the correct value added for each aircraft.

 Can someone take a look and let me know how to do this?  

Sheet one has the aircraft registration number and hours remaining until overhaul for each aircraft. Sheet 2 has the additional value I want to add based on the hours remaining (in 50 hour increments).

Thanks.
Aircraft-Value-Calculation.xls
ASKER CERTIFIED SOLUTION
Avatar of mark_harris231
mark_harris231
Flag of United States of America image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
What it does:

"MATCH(B3,Sheet1!$B$3:$AT$3,-1)"

This attempts to match the value of B3 in the range of hour values in row 3 on Sheet 1.  The "-1" at the end indicates that it should find the nearest value greater than B3 (in this case, 1350).  The result of this MATCH is the column number that the match is found (18th column in the array B3:AT3).

The INDEX() function instructs the formula to look at the array of B4:AT4 on Sheet1, and then select the value found in the 18th column of the row 4 array (20000 in this case).
Avatar of jwn0111
jwn0111

ASKER

Perfect.  Thank you.
John
My pleasure, John.  Thanks for the grade.