Mr. Ortiz is paid a salary of $575 each week and 5% commission on sales over $10,000 less any returned merchandise. His sales information is located in a spreadsheet where salary is in Cell B2, commission rate expressed as a decimal is in Cell C2, returns are in Cell D2, and total weekly sales are in Cell E2. What formula should be in Cell F2 to calculate Mr. Ortiz's net weekly pay?

Question

Quizplus · Accepted Answer

The Answer of Mr. Ortiz is paid a salary of $575 each week and 5% commission on sales over $10,000 less any returned merchandise. His sales information is located in a spreadsheet where salary is in Cell B2, commission rate expressed as a decimal is in Cell C2, returns are in Cell D2, and total weekly sales are in Cell E2. What formula should be in Cell F2 to calculate Mr. Ortiz's net weekly pay?

Mr Ortiz Is Paid a Salary of $575 Each Week