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 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