If a salespersons total sales are at least $110, their bonus is 40 percent of sales; if
Question:
If a salesperson’s total sales are at least $110, their bonus is 40 percent of sales; if their total sales are from $100 to $109, their bonus is 20 percent of sales. Otherwise, their bonus is 5 percent of sales. Write a LAMBDA formula named BONUS that will compute the correct bonus for any dollar amount of sales.
Fantastic news! We've Found the answer you've been seeking!
Step by Step Answer:
Related Book For
Microsoft Excel Data Analysis And Business Modeling
ISBN: 9780137613663
7th Edition
Authors: Wayne Winston
Question Posted: