Question

1 Approved Answer

Posted on Jul 16, 2024

3 5 Next, you want to display the city names that correspond with the city airport codes. In cell F7, Insert the SWITCH function to

3 5 Next, you want to display the city names that correspond with the city airport codes. In cell F7, Insert the SWITCH function to evaluate the alrport code in cell E7. Include mixed cell references to the city names in the range F2:F4. Use the airport codes as text for the Value arguments. Copy the function to the range FB:F36 OH AutoSave Data Review Formulas View Help File Home Insert Draw Page Layout fx Deline Name Use in Formula Name Manager Create from Selection Insert Function Ren ? A AutoSum Recently Financial Logical Text Date & Lookup & Math & More Used Time Reference Trig Functions Function Library fy Defined Names F7 X F H $ Cities Austin Dallas-Forth Worth Houston G Shipping $ 24 20 30 uus Shipping Shipping Cost Refund Shipped From D E 1 Input Area 2 Order Total Threshold $ 1,000 3 Total Days Delivery Goal 10 4 Shipping Refund Rate 50% 5 Date Date Date Airport 6 Ordered Shipped Arrived Total Days Code 7 4/5/2021 4/6/2021 4/9/2021 4 AUS B 4/5/2021 4/7/2021 4/15/2021 10 AUS 9 4/5/2021 4/7/2021 4/16/2021 11 IAH 10 4/5/2021 4/7/2021 4/12/2021 7 DFW 11 4/5/2021 4/9/2021 4/16/2021 11 IAH 12 4/5/2021 4/5/2021 4/12/2021 7 DFW 13 4/5/2021 4/8/2021 4/16/2021 11 AUS 4/6/2021 4/8/2021 4/15/2021 9 DFW 15 4/6/2021 4/6/2021 4/9/2021 3 DFW 16 4/6/2021 4/8/2021 4/19/2021 13 AUS 17 4/6/2021 4/8/2021 4/14/2021 8 IAH 1B 4/6/2021 4/9/2021 4/19/2021 13 DEW 19 4/7/2021 4/12/2021 4/16/2021 9 IAH 20 4/7/2021 4/9/2021 4/16/2021 9 AUS 21 4/7/2021 4/9/2021 4/14/2021 7 DFW 22 4/7/2021 4/24/2021 4/30/2021 23 DFW Week Stats Map Loan Car Reference F7 Order Total $ 975 S 1,055 $ 1,075 S 1,000 $ 2,535 S 1,890 s 950 $ 1,485 $ 550 $ 1,250 s 1,600 S 2,500 s 1,425 $ 800 $ 1,000 $ 1,125 3 5 Next, you want to display the city names that correspond with the city airport codes. In cell F7, Insert the SWITCH function to evaluate the alrport code in cell E7. Include mixed cell references to the city names in the range F2:F4. Use the airport codes as text for the Value arguments. Copy the function to the range FB:F36 OH AutoSave Data Review Formulas View Help File Home Insert Draw Page Layout fx Deline Name Use in Formula Name Manager Create from Selection Insert Function Ren ? A AutoSum Recently Financial Logical Text Date & Lookup & Math & More Used Time Reference Trig Functions Function Library fy Defined Names F7 X F H $ Cities Austin Dallas-Forth Worth Houston G Shipping $ 24 20 30 uus Shipping Shipping Cost Refund Shipped From D E 1 Input Area 2 Order Total Threshold $ 1,000 3 Total Days Delivery Goal 10 4 Shipping Refund Rate 50% 5 Date Date Date Airport 6 Ordered Shipped Arrived Total Days Code 7 4/5/2021 4/6/2021 4/9/2021 4 AUS B 4/5/2021 4/7/2021 4/15/2021 10 AUS 9 4/5/2021 4/7/2021 4/16/2021 11 IAH 10 4/5/2021 4/7/2021 4/12/2021 7 DFW 11 4/5/2021 4/9/2021 4/16/2021 11 IAH 12 4/5/2021 4/5/2021 4/12/2021 7 DFW 13 4/5/2021 4/8/2021 4/16/2021 11 AUS 4/6/2021 4/8/2021 4/15/2021 9 DFW 15 4/6/2021 4/6/2021 4/9/2021 3 DFW 16 4/6/2021 4/8/2021 4/19/2021 13 AUS 17 4/6/2021 4/8/2021 4/14/2021 8 IAH 1B 4/6/2021 4/9/2021 4/19/2021 13 DEW 19 4/7/2021 4/12/2021 4/16/2021 9 IAH 20 4/7/2021 4/9/2021 4/16/2021 9 AUS 21 4/7/2021 4/9/2021 4/14/2021 7 DFW 22 4/7/2021 4/24/2021 4/30/2021 23 DFW Week Stats Map Loan Car Reference F7 Order Total $ 975 S 1,055 $ 1,075 S 1,000 $ 2,535 S 1,890 s 950 $ 1,485 $ 550 $ 1,250 s 1,600 S 2,500 s 1,425 $ 800 $ 1,000 $ 1,125