Question: Enter functions in cell L10 that return the Early Booking Discount, based on column D, for the cost of the river trip. The discount will

  1. Enter functions in cell L10 that return the Early Booking Discount, based on column D, for the cost of the river trip. The discount will be 0%, 5%, or 10% and will be based on the following conditions:
  2. Adults with an early booking get a 5% discount if they have signed up for at least 2 nights in Las Vegas.
  3. Adults with an early booking get a 10% discount if they have signed up for at least 4 nights in Las Vegas. 
  4. All others get a 0% discount.

calculate  IF with a AND function? 



AutoSave On K201_GP7_SP23 Upload Blocked Search File Home Insert Draw Page Layout

AutoSave On K201_GP7_SP23 Upload Blocked Search File Home Insert Draw Page Layout Formulas Data Review View Automate Help D Verdana 10 Percentage Conditional Formatting Insert $ % Format as Table Delete Paste BIU .00 000 .00 Cell Styles Format Undo Clipboard Font Alignment ] Number Styles Cells X UPLOAD BLOCKED We couldn't verify you have the necessary permissions to upload the file. Save a Copy L12 234567 co 8 X fx B C D E F Departure Date: 30-Jun-23 Cost per Adult $ 1,799.50 Gratuities Included? No G H Grand Canyon + Las vegas Trip W T Joshua J Comments Share Sort & Find & Filter Select Editing Analyze Data Analysis Sensitivity Sensitivity | K M Name Birth Date Early Booking Deposit Number of Nights in Las Vegas Club Membership Hotel Accomodations Customer # Child or Adult Expedition Cost Early Booking Discount Cost of Las Sen Vegas Disco Package 9 10 Luis Flores 09/01/69 Yes $ 150.00 3 Bull Frogs Family 5 Adult $ 1,799.50 11 Wanda Flores 08/02/69 Yes $ 150.00 3 Bull Frogs Family 32 Adult $ 1,799.50 12 Isandro Flores 02/01/04 Yes $ 100.00 4 Bull Frogs Family 9 Adult $ 1,799.50 13 Alejandra Flores 04/26/06 Yes $ 1 Bull Frogs Family 66 Child $ 1,349.63 14 Benjamin Ficus 11/18/86 No $ 175.00 4 Rafting Fools Luxury 4 Adult $ 1,799.50 15 Aurea Ficus 10/05/86 No $ 250.00 4 Rafting Fools Luxury 96 Adult $ 1,799.50 16 Sana Bashir 08/24/86 No $ 100.00 0 Kayak Crazies Suite 42 Adult $ 1,799.50 17 Isa Bashir 01/16/08 No 100.00 0 Kayak Crazies Suite 34 Child $ 1,349.63 18 Tom Donner 08/13/70 Yes $ 125.00 6 Screaming Meemies Family 22 Adult $ 1,799.50 19 Wanda Donner 03/15/71 Yes $ 100.00 6 Screaming Meemies Family 17 Adult $ 1,799.50 20 Jamal Donner 05/06/99 Yes $ 25.00 2 Screaming Meemies Family 398 Adult $ 1,799.50 21 Lucas Donner 09/06/02 Yes $ 25.00 5 Screaming Meemies Family 4 Adult $ 1,799.50 22 Ian Donner 09/09/04 Yes $ 25.00 5 Screaming Meemies Family 55 Adult $ 1,799.50 23 Kevin Hostetler 05/07/76 No $ 50.00 1 Bull Frogs Economy 3 Adult $ 1,799.50 24 Casey Deal 07/03/98 No $ 5 Bull Frogs Family 72 Adult $ 1,799.50 25 Eric Kinser 05/24/79 Yes $ 190.00 6 Rafting Fools Suite 144 Adult $ 1,799.50 26 George Telthorst 07/02/86 Yes $ 150.00 7 Kayak Crazies Economy 327 Adult $ 1,799.50 27 Cindy Stone 08/20/58 No $ 2 Screaming Meemies Luxury 408 Adult $ 1,799.50 28 Adam Sweeny 04/12/73 No $ 25.00 2 Screaming Meemies Luxury 310 Adult $ 1,799.50 29 Carlee Andre 06/18/77 Yes $ 60.00 5 Rafting Fools Family 264 Adult $ 1,799.50 Documentation Products_List Shipping Costs Receipt Grand Canyon + Ready Accessibility: Investigate 53F Cloudy Search 19 N W + 90% 6:57 PM 4/6/2023

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!