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.
9 years ago
3
Answer(0)
Bids(0)
other Questions(10)
- for miss professor
- Discussion Board Assignment #9 M
- diversity and overcoming stereotypes with critical thinking consider how thinking critically and embracing diversity helps us to overcome stereotypes.
- Essay doe graduate application
- FIN 402 final
- Psychology Questions
- Proposal/Persuasive Report Assignment
- The vice president of marketing tells a marketing manager to prepare a presentation by the end of the week. The vice president is most likely exercising which of the
- see description below
- Forensic Science