Assignment 6 & 8
Using hLookup to fill in Salary (Set up a Salary table first as shown below).
Calculate total payment (Commission and Salary).
Determine the minimum, average, and maximum payment (Lowest, Average, and Highest), respectively.
Make sure to save your work
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.