Question
In column L (amount of commission) use an IF function to calculate the commission as follows: IF Average Sales for each salesperson >= $30,000 (use
In column L (amount of commission) use an IF function to calculate the commission as follows:
IF Average Sales for each salesperson >= $30,000 (use cell reference in M2)
TRUECalculate Bonus: Average Sales * 2.0% (use cell reference to N2)
FALSECalculate Bonus: Average Sales * 1.5% (use cell reference to N3)
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
Essentials Of Management Information Systems
Authors: Ken Laudon, Kenneth C Laudon
10th Edition
0133033090, 9780133033090
