Separate the salesperson name for each transaction to two fields for first and l

Question

Separate the salesperson name for each transaction to two fields for first and last name. In an adjacent to column, create an IF statement to calculate the fee for labor for each transaction. Fees should be 11% on sales under$500 and 9.5% on sales of $500 or more. In another column, calculate the total sale amount for each transaction including the labor fee. The region of the sale is indicated by the second character of the transaction number. Store the region of each transaction in its own column. Each salesperson earns a commission on every sale. Commission rates vary depending upon the region of the sale. Create a VLOOKUP table (several columns to the right of your data) for the following commission rates: Region 1 = 2.3% Region 2 = 2.9% Region 3 = 3.1% Region 4 = 3.7% Store the commission rate for each transaction by referencing the VLOOKUP table.

Explanation / Answer

IF(sales<500,sales*100/11)
IF(sales>500,sales*100/9.5)
in the place of sales use the column of your excelsheet.

this is how percentage is calculated
500/x=100/11
(500/x)*x=(100/11)*x
500=9.09090909091*x
500/9.09090909091=x
55=x
x=55

PLEASE RATE ANSWER HOPE IT HELP....

THANK YOU....

Related Questions

Navigate

• Browse (All)
• Browse S
• Subjects

---

---

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