FunctionPracticeIfPmtVlookup

FunctionPracticeIfPmtVlookup - Fuel Estimates Flying Hours...

Info iconThis preview shows pages 1–3. Sign up to view the full content.

View Full Document Right Arrow Icon
Fuel Estimates Plane Trip Boeing-727 MIA-JFK 2.75 3025 605 302.5 3932.5 DC-9 MIA-ATL 1.25 925 185 92.5 1202.5 DC-9 MIA-DFW 3.15 2331 466.2 233.1 3030.3 L-1011 MIA-SJU 3.50 11200 2240 1120 14560 L-1011 MIA-IAH 2.25 7200 1440 720 9360 Boeing-727 MIA-LAX 5.50 6050 1210 605 7865 DC-9 MIA-MSY 1.50 1110 222 111 1443 Totals 31,841.0 6,368.2 3,184.1 41,393.3 Average Value 4,548.7 909.7 454.9 5,913.3 Maximum Value 11,200.0 2,240.0 1,120.0 14,560.0 Plane Range (miles) Gallons/HouFuel Information Boeing-727 2,200 1,100 Threshold number of gallons for price break DC-9 1,200 740 Price per gallon if threshold is reached L-1011 3,000 3,200 Price per gallon if threshold is not met Percent of flying fuel required for reserves Percent of flying fuel required for holding Flying Hours Fuel Required Reserve Fuel Holding Fuel Total Fuel
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
4 ways to slice an IF function Cost Cost Cost Cost $11,404.25 $11,404.25 $11,404.25 $11,404.25 $350.08 $3,487.25 $3,487.25 $3,487.25 $3,487.25 $107.05 $8,787.87 $8,787.87 $8,787.87
Background image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

Page1 / 4

FunctionPracticeIfPmtVlookup - Fuel Estimates Flying Hours...

This preview shows document pages 1 - 3. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online