139

Formula And Functions

 Using the following scenarios, discuss how you would apply the Excel functions or create a formula to solve the scenario. Be specific!

You wish to calculate the commission on sales. The commission is 6% on all sales that are at least 20% above cost.

You wish to calculate the total pay for an employee who receives regular time for 40 hours, time and a half for 40–50 hours, and double time for hours over 50.

You have a list of contracts and due dates for annual maintenance fees. You wish to determine when you have a contract due in the next 45 days and provide a note that warns you that the payment is due.


Question Field

Asked by rhensley
3 years ago
NO ANSWERS YET
RELATED QUESTIONS
84 Rank 414 Views
 CIS 111

Asked by christopher85 3 years ago

765 Rank 927 Views
691 Rank 501 Views
 -

Asked by morgan36 3 years ago

1005 Rank 947 Views
1259 Rank 699 Views
1138 Rank 87 Views
 Database Design

Asked by nbruce 3 years ago

611 Rank 999 Views
 Case Study Part 3

Asked by fwilliams 3 years ago

1025 Rank 566 Views
61 Rank 331 Views
 Tutor KelvinBob

Asked by deanlindsey 3 years ago