On Trip Fee Sheet: Using hLookup to set up only one Lookup table. After you fini

Question

On Trip Fee Sheet: Using hLookup to set up only one Lookup table. After you finish the following processes, when you enter a trip ID, the rest of information filled in the table automatically:

Using Trip ID to lookup each trip information.

Calculate field Trip Fee that times Fee and Person.

Use the If function to reduce TripFee by 10% if the people is greater than or equal to ten (10).

Calculate Total trip fee.

Trip ID 3002 3003 3009 3010 3050 3107 3142 3179 3190 3204 3222 3395 3488 3503 3515 3529 3611 3628 3670 3675 River Arkansas River (Brown's Canyon) Arkansas River (Parkdale) Arkansas River (Royal Gorge) Colorado River (Westwater Canyon) Colorado River (Grand Canyon) Arkansas River (Brown's Canyon) Colorado River (Little Gore Canyon) Arkansas River (Royal Gorge) Arkansas River (The Numbers) Arkansas River (The Narrows) Colorado River (Little Gore Canyon) Arkansas River (The Narrows) Arkansas River (Brown's Canyon/Royal Gorge) Colorado River (Glenwood Canyon) Colorado River (Little Gore Canyon) South Platte River Clear Creek River Clear Creek River South Platte River Colorado River (Grand Canyon) # of Person 8 10 12 17 4 22 20 5 18 9 23 25 7 18 25 10 9 20 18 3 TripDays 0.5 0.5 0.5 2 5 1 1 1 1 0.5 2 1 2 1 3 0.5 0.5 1 1 2.5 Fee/Person $45.00 $40.00 $45.00 $180.00 $125.00 $75.00 $85.00 $85.00 $70.00 $85.00 $225.00 $145.00 $199.00 $80.00 $360.00 $35.00 $45.00 $95.00 $75.00 $215.00 Colorado Trip Lookup Table Enter a Trip ID River # of Person TripDays Trip Fee Discount Total

Explanation / Answer

Calculate field trip fee:

Fee is give for per person so no of days is not relavent. total fee = no. of person * fee per person less discount applicable.

Trip id 3002 3003 3009 3010 3050 3107 3142 3179 3190 3204 3222 3395 3488 3503 3515 3529 no of persons 8 10 12 17 4 22 20 5 18 9 23 25 7 18 25 10 fee/person 45 40 45 180 125 75 85 85 70 85 225 145 199 80 360 35 Total fee 360 400 540 3060 500 1650 1700 425 1260 765 5175 3625 1393 1440 9000 350 Discount 0 40 54 306 0 165 170 0 126 0 517.5 362.5 0 144 900 35 Net fee 360 360 486 2754 500 1485 1530 425 1134 765 4657.5 3262.5 1393 1296 8100 315

Related Questions

Navigate

• Browse (All)
• Browse O
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.