Question
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started