Question: TIPS Write an Excel formula in cell VACATION!B13, which can be copied down to VACATION!B18, to determine which direction the plane will fly to get

TIPS Write an Excel formula in cell VACATION!B13, which can be copied down to VACATION!B18, to determine which direction the plane will fly to get the family from Columbus, OH to their travel destination. Based on a world map. Asia is to the west of Ohio, Europe is to the east, and South America is to the south. O=IF(F4="Asia","West",IF(F4="Europe","East","South")) O=IF(F4="Asia":"West",F4="Europe",IF("East", "South")) =IF(F4="Asia". "West".F4="Europe","East", F4="South America":"South") O=IF("Asia","West",IF("Europe","East","South")) TRAVEL PACKAGE FORMATION de O Part TE TITA 100AL THE G Erre C. TO INT TOUTES XLNO C D re SON 12 TEM 14.000 O O Le Some 3 TAS TERTPAMILY Travel Court Travel Centet Awane Tweel 12 Fanny Direto Tre Altre AM Tulo 27000000000000000 14 Al 12.000 HOOTED 15 We BE78000000000 11000 TE 10 W E 1000000 1 7.00020000 151 10 We 3170.00 GOU 19 20 people at Commercete Asia 21 pretcher? 22 the miles te Asire there to ridere TRA 23 In the preparater 49 TELE 24 Whether with the terme 2004 25. What the merge Lowest Travel A? Wegfare for familiegte Anithathew 20 Best OnWate 5700000 TRUE Wibe total destination for face 0721 VACATION B D Country Japan Norway Chile 2 Currency yen kroner peso 3 Currency/S 109.67 6.93 594 46 COUNTRY E Peru nuevo 3.35 G Thailand China bhat yuan 39.7 329 1 Cost of fuelgallon 2 Miles/gallon B $100 120 1 Cost of trip Tip 2 50 5% 3 $10.000 7% 4 $16000 10% 5 $25 000 12 6 $30,000 15% UNITS TIDS
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
