Answered step by step
Verified Expert Solution
Question
1 Approved Answer
3. Type the title Commission in cell E2. 4. In cell E3, calculate the commission using a formula that multiplies projected sales by the commission
3. Type the title Commission in cell E2. 4. In cell E3, calculate the commission using a formula that multiplies projected sales by the commission rate. Hint: Use an absolute reference for cell B18. Copy the formula in cell E3 to cells E4:E12. 5. Type the title Salary in cell F2. 6. In cell F3, calculate the salary by adding the base salary and the commission. Copy the formula in cell F3 to cells F4:F12. 7. Type the title New Salary in cell G2.
I am having problems on commission rate
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started