Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Below are 7 functions I did. It wants me to add the functions I did and put them in the charts below. I can't seem

Below are 7 functions I did. It wants me to add the functions I did and put them in the charts below. I can't seem to figure out how to properly put the functions in the charts below correctly.

=IF(,Flights!B3 "Available", "Not Available")

=IF(AND(Analysis!B3="Available",Analysis!C3="Available",Analysis!D3="Available"), "All", "Not All")

=IF(flights available to any of the 3 destinations, display At Least One, display None)=IF(OR(CellAnalysis!A3="Available",CellAnalysis!B3="Available",CellAnalysis!C3="Available"), "At Least One", "None ")

=IF(COUNTIF(Analysis!B3:H3, "Available")>1, "At Least Two", "Less Than Two")

=IF(AND(D3="Available", OR(C3="available"), "Will Fly", "Will Not Fly")

= B3 - (IF($A3="America West",Discounts!$A$3, IF($A3="American",Discounts!$B$3, IF($A3="Continental",Discounts!$C$3,Discounts!$D$3))) * B3)

=IF(B3 >=20, "Frequently", IF(B3 >=10, "Occasionally", IF(B3 >=1, "Seldom", "Never")))

Number of Flights From Columbus to Destination Flight Frequency From Columbus to Destination
Airline Boston New York Chicago Boston New York Chicago
America West 7 6 5
American 1 8 4
Continental 1 4 10
Delta 0 0 0

Flights From Columbus to Destination
Airline Boston New York Chicago All Locations At Least 1 Location Flies to at Least 2 Locations Martha Will Fly
America West
American
Continental
Delta

Airline Fare From Columbus to Destination Discounted Fare
Airline Boston New York Chicago Boston New York Chicago
America West $250.00 $300.00 $450.00
American $225.00 $275.00 $500.00
Continental $210.00 $350.00 $350.00
Delta $275.00 $310.00 $475.00

Fare Discounts
Airline: America West Airline: American Airline: Continental Airline: Delta
15% 10% 8% 5%

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Mathematical Applications For The Management, Life And Social Sciences

Authors: Ronald J. Harshbarger, James J. Reynolds

12th Edition

978-1337625340

More Books

Students also viewed these Mathematics questions

Question

Reporting Stockholders' Equity reacquired

Answered: 1 week ago

Question

6-11. What else (if anything) would you suggest?

Answered: 1 week ago